I need them to by 1 EXample

1 2 4 5 10 11 15 16 -19 24 0 -13 0 2 0 -9 0 0 0
0 0 -3 0 1 0 -46 1 - 0 0 -11 0 -120 0 0 0 5 -1 1 0
Total 4 2 3 3 4 3 4


"Mike" wrote:

I need this do count both negative and positive

"RagDyeR" wrote:

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