"Teethless mama" wrote in message
...
=SUM(COUNTIF(INDIRECT({"A1","C1","E1"}),"<0"))
It looks like it should work but in XL97 it returns 3 for me because
=COUNTIF(A1,"<0") returns 1
I don't know if it is the same in all versions.
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Teethless mama" wrote in message
...
=SUM(COUNTIF(INDIRECT({"A1","C1","E1"}),"<0"))
"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