But i need to have the other references in there too..

=SUMIF(B2:B122,C123,D2:D122)

where would i insert your 'countif' bit in?

If this works then i need not post my sample file but if it doesnt i will.

thanks.

"Ron Rosenfeld" wrote:

On Fri, 1 Feb 2008 03:38:15 -0800, Zak wrote:

I have the following SUMIF statement but i would like to modify the formula
so it only counts the the negative numbers, i tried if<0 but no luck.

=SUMIF(B2:B122,C123,D2:D122)

the D reference should say somewhere 'if less than 0' - so it only counts
negative numbers.

thanks for your help.


To count negative numbers:

=countif(rng,"<0")

Perhaps you want to do something else?



--ron