duplicate - Group By

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
 
R

Roger Govier

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Button - Dashboard 0
Copy & Paste Problem. 2
CBO List 2
Group Summary 2
Need Help with Parameters 1
Copy & Pasting Problem ? 0
Excel Copy & Paste Issue ?? 5
Sum if statement - Queries 3

Top