counting entries

  • Thread starter Thread starter mexmex
  • Start date Start date
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.
 
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

Counting an entry in cells 3
Help needed 0
How do I sum numbers based on other data 6
Count number of days from the last entry? 2
Counting the number of entries in a column 7
Excel VBA - counting cells by colors and names to it in two different rows. 0
Determing n=? using COUNT 2
formula to count text entries and return text with most entries 8

Back
Top