COUNTIF and ISTEXT

C

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.
 
R

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
Click to expand...
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.
 
Top