COUNTIF and ISTEXT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi Chuck,

=COUNTA(A:A)-COUNT(A:A)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Chuck said:
I have started a list of volunteers by last name.
After I have finished entering all the names I would like EXCEL to count
Click to expand...
the number of volunteers entered on the list. EXCEL would ignore all the
empty cells at the end of the list.
 
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.
 
Hi Bob
Would you explain the -COUNT(A:A) on the end.
I tried it and it gives the right answer but on double
clicking on formula cell, then them pressing enter the
formula stays in view not the answer.
It's as if you have started the formula with a ' to stop
it working.

I entered the names as a text range.

Hope you can understand this.

Bob C
 
Hi again Bob
The formula cell is changed from General to a text format
and you have to double the cell then come off it and
double click again for this to happen.
I came across this due to entering the formula
incorrectly (used 2 COUNTA's).
I entered the names in text format to see if the formula
would work on text formatted data.

Bob C
 
Back
Top