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

[Guest]

THE FORMULA THAT I HAVE WILL COUNT ALL POSITIVE #'S IN RANGE AND
I KNOW THAT IF I CHANGE MY FORMULA TO READ =COUNTIF(D429,"<0") THIS WILL
COUNT ALL MY NEGATIVE #'S IN RANGE. BUT WHAT I NEED IS TO COUNT ALL
#'S >0 AND <0

PLEASE HELP

 

[Mallycat]

How about =COUNTIF(D429,"<>0")

 

[Guest]

Very non-robust. See my response in the earlier thread.

Jerry