COUNTIF number is NOT zero.

[koalamotorsport]

I need to count cells in a column that are not zero.

The cells are formula results that could be positive or negative.

COUNTIF(A1:A10)">0" should return a count of all cells above zero, but I have cells below zero that need to be counted also.

There are cells with zero because that's what Excel puts in if you have a formula in the cell that is not yet realized because of no data in the calculated cells.

Thanks.
Brett

[Crooza]

Try this

COUNTIF(A1:A10,"<>0")

[koalamotorsport]

Try this

COUNTIF(A1:A10,"<>0")

Computers are not my friend today. This is my third attempt at commenting on this. Copy and paste is becoming my friend!

Crooza, I had entered exactly that in my formula bar, manually. It did not work. It created an error. I went back to the Formula tab and chose Statistical and filled in the necessary fields. The automatic generation looked identical to what I had entered manually, =COUNTIF(P991:p1508),"<>0", but this time it worked. Strange idiosyncrasies of software I guess.