duplicate - Group By

[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

 

[Roger Govier]

Hi
Select your range of data>Subtotals>at each change in>Sport>Sum># of players

 

[zodiac711]

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

 

[Bernd P]

Hello,

http://www.sulprobil.com/html/sfreq.html

Regards,
Bernd