JeffBeall
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?
=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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I guess you had a typo helpfinder, using the comma after the 3 worked
Thank you so much! that works great.
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.
ASKER
=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.