SUMIF alternate?

Hello! I'm new to the thread and I am hoping someone can help with my specific problem or maybe point me in the right direction so I can learn how to solve.

For the example table:
Group Email
A [email protected]
B [email protected]
A [email protected]
A [email protected]
C [email protected]

I need to find all the unique "Groups" and provide a count for each Group. I can probably do this using the SUMIF function, but I think that will require some unnecessary work. There has to be a more efficient way. The table I'm working with has 100k records and up to 94 unique "groups".

Thanks for the help!

Easiest would be a pivot table (Insert tab> Pivot Table. Use Group in Row Labels and in Values (Count of Group).

Alternate, With Excel 2007, copy your group column to a new column and then delete duplicates
Data tab> Remove duplicates. Then do CountIF in the next column
Either of these work for you?