Given a name, how can I find the subtotal of rows matching that name?

[Sir Funk]

Good morning,

I have a large list of data associated with a person's name. I would like to get a count of how many items are in that list given a person's name.

That is, instead of having a subtotal at the bottom of the list and filtering the list by each person's name to get their count, I would like another tab that lists each person's name and is able to dynamically count how many times that person's name appears on the list in the first tab. I've already extracted each of the unique names on the list, I'm just having trouble constructing a function to finish my task.

I hope I'm explaining myself correctly, it's still pretty early in the morning here!

Thanks!

 

[Jonmo1]

Try the countif function...

=COUNTIF('Sheet1'!A:A,A2)

Where Sheet1 column A is the original data,
And the formula is on another sheet with your unique list of names starting in A2

Hope that helps.

 

[VoG]

Hi. Perhaps

=COUNTIF(Sheet1!A:A,A1)

where A1 holds a person's name and the list is in column A of Sheet1.

 

[Sir Funk]

Yup, duh...

Thanks both for your quick responses!