try
=COUNTIF(C3:C20;"0") if entry data is numeric or

another way by chip person www.cpearson.com
array formula (ctl+shift+enter)
=sum(if(C3:C20<"";1;0)) any type of data (String ,Number)


"Wellie" wrote in message
...
I have a range of cell e.g. (C3:C20). I need to count #
of cells that users have entered any data.

Is the following worksheet function the correct one ?

=@countif(C3:C20),"")

If each cell from C3:C20 is blank, I expect it returns 0.
If I enter data in C5, C7 & C9, I expect it returns 3.

If not, what function should I use, please advise.

Thanks again for any help.