Excel - Count cells in a row that have a value != 0?

[WannaFly]

I need to get the count of all cells in an entire row that has a value != 0, how do I do that? Thanks.

 

[KLin]

Originally posted by: WannaFly
I need to get the count of all cells in an entire row that has a value != 0, how do I do that? Thanks.

groups.google.com rocks

 

[WannaFly]

Thanks again KLin, Apparently COUNTIF cannot take an entire column(i meant colum initiall), but I gave it the range of the whole thing minus the last cell and that worked.

 

[petesamprs]

countif should work for an entire column. If your data is in column A, your formla is: =COUNTIF(A:A,"<>0"). Of course this will count all blank cells as well. If you only want cells with a non-zero value, then do =COUNT(A:A)-COUNTIF(A:A,"0")