I need some help with a formula to calculate the total of monies collected by
Teams for a Relay. I want to make a Summary on one sheet based on data on
another sheet.

Team A has 15 members, Team B has 10. Money totals collected by members are
in Sheet 3 and I want the summary to be on Sheet 1 by Team.

Here is a sample of the data.

Team A, Member 1 collected $10
Team A, Member 2 collected $20
Team B, Member 1 collected $30
Team C, Member 3 collected $5

How do I get the total for each of the teams? Thanks so much.

Could you give a little more info. Like lets look at sheet 3
Is all data stored in Column A like this
A
1 Team A, Member 1 collected $10
2 Team A, Member 2 collected $15
3 Team C, Member 1 collected $10
4 Team B, Member 4 collected $45

or is the data stored in 3 columns like this
A B C
1TEAM Member Collected
2 A 1 $10
3 A 2 $15
4 B 1 $20

"NeedHelpFast" wrote:

I need some help with a formula to calculate the total of monies collected by
Teams for a Relay. I want to make a Summary on one sheet based on data on
another sheet.

Team A has 15 members, Team B has 10. Money totals collected by members are
in Sheet 3 and I want the summary to be on Sheet 1 by Team.

Here is a sample of the data.

Team A, Member 1 collected $10
Team A, Member 2 collected $20
Team B, Member 1 collected $30
Team C, Member 3 collected $5

How do I get the total for each of the teams? Thanks so much.

Assuming team in column A, money in C

=SUMIF(Sheet3!A:A,A1,Sheet3!C:C)

where A1and down holds the team names on Sheet 1

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"NeedHelpFast" wrote in message
...
I need some help with a formula to calculate the total of monies collected
by
Teams for a Relay. I want to make a Summary on one sheet based on data on
another sheet.

Team A has 15 members, Team B has 10. Money totals collected by members
are
in Sheet 3 and I want the summary to be on Sheet 1 by Team.

Here is a sample of the data.

Team A, Member 1 collected $10
Team A, Member 2 collected $20
Team B, Member 1 collected $30
Team C, Member 3 collected $5

How do I get the total for each of the teams? Thanks so much.

Let me try this again

Sheet name = Summary
A21 = Team Name 1
A22 = Team Name 2
A23 = Team Name 3
In Col B on Summary page, I want to total the monies collected by each team.

Sheet Name = Monies contains

Col A Col L Col Q
Member 1 Team 1 $10
Member 2 Team 1 $15
Member 1 Team 2 $12
Member 1 Team 3 $49

Hopefully this is a better example. Any help is appreciated. Thanks

Paste this into your Summary Sheet Cell B23
=SUMIF(Monies contains !L:L,A23,Monies contains !Q:Q)


"NeedHelpFast" wrote:

Let me try this again

Sheet name = Summary
A21 = Team Name 1
A22 = Team Name 2
A23 = Team Name 3
In Col B on Summary page, I want to total the monies collected by each team.

Sheet Name = Monies contains

Col A Col L Col Q
Member 1 Team 1 $10
Member 2 Team 1 $15
Member 1 Team 2 $12
Member 1 Team 3 $49

Hopefully this is a better example. Any help is appreciated. Thanks

=SUMIF(Monies!L:L,A21,Monies!Q:Q)
Enter in summary sheet cell B21 and copy down to get totals for each team.

"NeedHelpFast" wrote:

Let me try this again

Sheet name = Summary
A21 = Team Name 1
A22 = Team Name 2
A23 = Team Name 3
In Col B on Summary page, I want to total the monies collected by each team.

Sheet Name = Monies contains

Col A Col L Col Q
Member 1 Team 1 $10
Member 2 Team 1 $15
Member 1 Team 2 $12
Member 1 Team 3 $49

Hopefully this is a better example. Any help is appreciated. Thanks

Your answers worked. Thanks for the help.


"NeedHelpFast" wrote:

Let me try this again

Sheet name = Summary
A21 = Team Name 1
A22 = Team Name 2
A23 = Team Name 3
In Col B on Summary page, I want to total the monies collected by each team.

Sheet Name = Monies contains

Col A Col L Col Q
Member 1 Team 1 $10
Member 2 Team 1 $15
Member 1 Team 2 $12
Member 1 Team 3 $49

Hopefully this is a better example. Any help is appreciated. Thanks