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

M

Mike

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

PLEASE HELP
 
Top