Count Q
=COUNTIF(A1:A1,"<0")+COUNTIF(C1:C1,"<0")+COUNTIF (E1:E1,"<0")
or
=(A1<0)+(E1<0)+(C1<0)
--
Gary''s Student
gsnu200710
"Sean" wrote:
How can I count up the number of non "Zeros" in A1, C1, E1?
I can't use a simple COUNTA as I may have "Zeros" in some cells and I
don't want those included in my answer
Thanks
|