sumif
 

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.

sumif
 

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

"VielExcel" wrote:


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.




--
VielExcel

sumif
 

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

On Nov 25, 9:46*am, VielExcel
wrote:
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.

--
VielExcel