View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default How to count it?

Hi Eric
Try this in Cell B1:
=COUNTIF(A:A,"?*")
Regards - Dave

"Eric" wrote:

Does anyone have any suggestions on how to count it?
There is a list of name under column A, such as John, Mary, Ann ...
I would like to count the number of name under column A, the condition is to
count one as long as the cell is not equal to "".
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric