counting cells rather than their content

[Stclements]

I have a column of cells each numbered in numerical order, 1,2,3,4,etc
Is there a function in excel that allows me to count how many cells in that column have a value rather than calculating the value of the cells.

I:E 1,2,3,4,5,6,7,8 would equal 36, what I want it to return is 8 because that is the number of cells with a value.

 

[pvr928]

Hi Stclements

=COUNTIF(A1:A8,">0") , or =COUNTIF(A1:A8,"<>0") if the range contains negative numbers and you want to count those too.

Cheers

pvr928

 

[Stclements]

Perfect, many thanks.