counting entries

M

mexmex

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

Dave Peterson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to average last 25 entries in a column? 4
Excel VBA - counting cells by colors and names to it in two different rows. 0
Auto concantenate 1
How do I sum numbers based on other data 6
Counting an entry in cells 3
Counting the number of entries in a column 7
Copying a formula to a range 2
Multiple entries query 6

Top