View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Christina Christina is offline
external usenet poster
 
Posts: 66
Default How can I add a column of names for example



"Ron Coderre" wrote:

This formula counts the number of non-blank cells in A2:A5
=COUNTA(A2:A5)

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"christina" wrote in message
...
I have A2 = adrienne, A3 = Joe how do I do the formuala to make their
names
= 2