Counting entries

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

alexm999

Doesn't seem to work. I've adapted it to suit me using B10:B:9999 and i
counted 1248 entries
 
Did you try this? =COUNTA(B10:B9999)

Are the cells actually blank, or is there something in the cell like a
space?

=ISBLANK(B17) ( put a cell that appears to be blank in the formula and
it will either show true if blank, or false if something is in the cell)
 
You must log in or register to reply here.

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

Search two columns in list for first and last name and return Id 4
Last 4 digit 6
Using ? in criteria 2
Finding 2nd last entry 3
Follow up Question to Countif 4
How to Populate Data from a table to another 0
How to specify a range from arbitrary cell and to "end of worksheet" 5
SumIF based on Multiple Conditions 7

Back
Top