Sumproduct is the best method

=Sumproduct(--(A1:A4465=Criteria1),--(B1:B4465=Criteria2),--(C1:C4465=Criteria3))


You can put as many or few criterias in the formula. to get percentage
simply divide by 4465 and format the cell with the formula to show percentage.

"Big Kahuna" 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.