View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wellie[_2_] Wellie[_2_] is offline
external usenet poster
 
Posts: 8
Default Counting empty cell

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.