I have a list of names in a column and want to show the total number of
entries in the column at the bottom.
--
Max

Hi,

Providing there are no numbers in the range this should do

=COUNTA(A1:A20)

Mike

"mexmex" wrote:

I have a list of names in a column and want to show the total number of
entries in the column at the bottom.
--
Max

If you want to simply count the number of entries in the range, you can use a
formula like:

=counta(a1:a10)
(where A1:A10 contain your data)

If you wanted to count the number of unique entries in that range, you could use
a formula like:

=sumproduct((a1:a10<"")/countif(a1:a10,a1:a10&""))
(you can only use the entire column in xl2007)



mexmex wrote:

I have a list of names in a column and want to show the total number of
entries in the column at the bottom.
--
Max

--

Dave Peterson