Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

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.
0
JeffBeall
Asked:
JeffBeall
1 Solution
 
regmigrantCommented:
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now