sumif

[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

 

[Dkline]

=SUMIF(range of cells,"<0")

 

[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