I was thinkning the same thing, If you right click on the gray bar at the
bottom of Excell the menu pops up in which you can click "count".
now after you have filtered/sorted your data, highlight all the maching
entries, i.e. click the top cel then hold down CTRL and Shift then press the
down arrow. Now the gray bar at the bottom shows the count of all cells
highlighted.

"Gord Dibben" wrote:

First of all, I don't think you are "sorting".

Sounds like you are "filtering".

See help on the SUBTOTAL function to get a count of filtered items.


Gord Dibben MS Excel MVP

On Fri, 20 Feb 2009 07:07:01 -0800, Big Kahuna <Big
wrote:

I have a worksheet with 4465 rows of data. The data is sortable using the
list function. Any combination of sorting criteria brings back a different
set of results.

I want to be able to know the number of rows ( each row is a person) so that
I can see how many people out of the total number fall into a particular
category.

Even better would be a percentage, but by getting the number of people I
could manually convert to percentage.

Much appreciated for any adivce in advance.