help with a formula for counting
 

I have numbers in col d and have done
=count(d3:d70) which gives me total of
items but i would like to modify it to only
add 1 if the cell is < 0.
can anybody showme how to do this?


--
wwoody
------------------------------------------------------------------------
wwoody's Profile: http://www.excelforum.com/member.php...o&userid=17362
View this thread: http://www.excelforum.com/showthread...hreadid=497799

help with a formula for counting
 

Hi ,

Just change your formula to
COUNTIF(D3:D70,"<0")

HTH
Cheers
Carim

help with a formula for counting
 

i tried it but it did not work. no count was made.


--
wwoody
------------------------------------------------------------------------
wwoody's Profile: http://www.excelforum.com/member.php...o&userid=17362
View this thread: http://www.excelforum.com/showthread...hreadid=497799

help with a formula for counting
 

Are you sure there is no confusion between 0, spaces , blanks ...?