Counting entries

  • Thread starter Thread starter alexm999
  • Start date Start date
A

alexm999

I have a bunch of names in coloumn B that i'd like counted. I manuall
counted all of them and it came out to 574 entries. When i use Count o
Countif it tells me I have 779 entries.
I'm doing something wrong. Can someone tell me what the correct verbag
is to count all entries in coloumn B.
Also, i will be adding an entry or 2 every day so i need the count t
update automatically
 
I used this to count all non-blank entries:

=COUNTIF(F4:F8,"<>""")

Note that there are three double-quotes after the <> sign.
 

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 count TWO conditions are met 3
n=? in each column 4
How to get the Total count 6
Counting the number of entries in a column 7
counting words 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Counting the dates in a column 1
How many days in a row does an employee work within a 2 month peri 2

Back
Top