Count # of People at Each Email Domain

[mcgonma]

Column F has 130 email addresses from 29 different domains. Column H has just the domain name from after "@".
How do I do a count of how many people there are from each of the 29 domains?

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=countifs(f:f,"*"&h2)

 

[mcgonma]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=countifs(f:f,"*"&h2)

I am using Office 365 for this situation. Thank you for that tip. I immediately went out to update my profile.

Where would I put your suggested formula?

Is there any way to use pivot tables for this, or am I not thinking about that correctly? I believe that might not work, though, because I have a number of blank cells in the data as it is an export of survey responses from survey monkey and the data spans A1: CG132.

 

[Fluff]

Thank you for that tip. I immediately went out to update my profile.

Thanks for that.

Where would I put your suggested formula?

anywhere you like, but I2 would make sense if the data in col H starts at row2