Counting number of rows

L

Lynne Mawson

I have taken information from other sources and want to count how many rows I
have without physically counting them as they have been inserted into the
worksheet out of sequence. Is there a way to do this?
 
R

Roger Govier

Hi Lynne

=COUNTA(A:A)
will give you the number of cells in column A with data
 

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

How to count the numbers in a Word document? 0
Section and Page numbering 0
Count number of text rows??? 3
WORD VBA Search and switch to advanced ... 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
How to have two tables on same line? 1
Count in a range of numbers 9

Top