=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