duplicate - Group By

  • Thread starter Thread starter learning_codes
  • Start date Start date
L

learning_codes

Hi,

I'm having a trouble understanding how to use a group by total.

I have many duplicates but want to group by total.

I have right now and see below.

Sport # of players
Hockey 20
Hockey 10
Hockey 13

Baseball 10
Baseball 4

I want to see like this:

Sport # of players
Hockey 43
Baseball 14

Your help would be much appreciated.
Thanks
 
If your data was laid out something like:
Hockey 20
Hockey 10
Baseball 10
Baseball 4
Hockey 13

You could use an array formula to calculate the below:
Hockey 43
Baseball 14


=SUM((B1:B5)*(A7=A1:A5))
Where A1:A5 are the sport names, B1:B5 are the values, and A7 is the sport
you want to look at. Be sure to use CTRL+SHIFT+ENTER as it's an array
formula.

Where you
 
Back
Top