sumif

V

VielExcel

Hi all,

I would like to know the sumif formula if I want to add all values >0
or all negative values in a column
 
P

Pete_UK

Which column?

You could try something along these lines:

=SUMIF(check_column,">0",sum_column)

or

=SUMIF(check_column,"<0",sum_column)

so that it might look like:

=SUMIF(A:A,">0",B:B)

Hope this helps.

Pete
 
Top