Have you tried this:

=COUNTIF(D4:D29,"<0")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Mike" wrote in message
...
I need this formula to also count negative numbers