=COUNTIF(D4:D29,"<0") will count anything not zero (empty cells, text,
booleans, errors, etc). It also behaves strangely on sheets where the last
row ever used is <29.

To count only positive or negative numbers, use
=COUNTIF(D4:D29,"0")+COUNTIF(D4:D29,"<0")

Jerry

"Dave Peterson" wrote:

Maybe...

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



Mike wrote:

I need this formula to also count negative numbers

--

Dave Peterson