IF formula
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
|