Hi

Maybe
=COUNTIF(D3:D100"<0")

--
Regards

Roger Govier


"wwoody" wrote in
message ...

Sorry but i have + and - numbers in the d col and i just want the
record
count.


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