Maximizing Connectivity & Productivity

Excel – Using SUMIF() to add only certain figures using criteria

So you don’t want all the numbers in a column added, using the SUM() function.

Use the SUMIF() function to specify which figures are to be added, by specifying the criteria that Excel should use to identify these figures.

ex. if you want to add only the negative figures, you can use the following:

=SUMIF(range,”<0″)

or, to add only the positive figures:

=SUMIF(range,”>0″)

 

Leave a Reply

You must be logged in to post a comment.

E-mail: info@netlogistix.com
Mississauga, ON, Canada 905.607.3500