COUNTIF and ISTEXT

[Chuck]

I have started a list of volunteers by last name
After I have finished entering all the names I would like EXCEL to count the number of volunteers entered on the list. EXCEL would ignore all the empty cells at the end of the list
Thanks for your help.

 

[Robert Christie]

Hi Chuck
With names in column A.
In column B enter =COUNTA(A:A)
HTH
Bob C

-----Original Message-----
I have started a list of volunteers by last name.
After I have finished entering all the names I would

like EXCEL to count the number of volunteers entered on
the list. EXCEL would ignore all the empty cells at the
end of the list.