ms excel 2010

I have an excel document with about 2000 rows. I have it sorted to select about 700 rows, but I don't know the exact amount of rows.
Is there a way to get the exact amount of rows?
In the formula tab, under other formulas, I tried count, and gave a range of rows, but it always comes up with 0.
LVL 1
JeffBeallAsked:
Who is Participating?
 
regmigrantConnect With a Mentor Commented:
if you use 'autofilter' it will give a count the number of rows filtered at the bottom left of the sheet.

if you use the '=count' formula it will only count numbers, use '=counta' to count text values, but this will ignore blanks and you will need to select just one cell from each row because it counts individual Cells not rows.

If you have sorted it in the sheet and need the top set of rows then the row numbers down the side will tell you how many there are

It would be much easier if you gave us more to go on - such as a sample of the data and what makes the rows you want to count special
0
 
JeffBeallAuthor Commented:
Thank you, the =counta thing worked great
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.