I just opened a question about counting the number of rows, it turned out that
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
as so on, obviously due to the filter, but my formula is
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?