Link to home
Start Free TrialLog in
Avatar of JeffBeall
JeffBeallFlag for United States of America

asked on

ms excel sort

I just opened a question about counting the number of rows, it turned out that

=COUNTA(E1:E2000)

counts the rows as per the regmigrant's suggestion

Now I am having a problem with sorting. So I need to sort the excel doc, then total the rows.
But when I sort the rows, the numbers of the rows is all off, for example the numbering goes

2,3,6,7,15,16

as so on, obviously due to the filter, but my formula is

=COUNTA(E1:E2000)

my count is 2000 no matter how I filter the document.
So how can I get an accurate count of the rows after I apply the filter?
SOLUTION
Avatar of helpfinder
helpfinder
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JeffBeall

ASKER

OK, I tried

=SUBTOTAL(3;E1:E2000)

but I get this message

"The formula you typed contains an error"

there are some suggestions, but it's just things like click help for more info.
ASKER CERTIFIED SOLUTION
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I guess you had a typo helpfinder, using the comma after the 3 worked
Thank you so much! that works great.
it´s not a typo. if comma or semicolon is a separator depends on Regional Settings and what you have set.