Total a column from sheet 2 based on value in sheet 1

[NeedHelpFast]

Col B Col C Col F
Mary Team 1 $331.00
George Team 1 $222.00
Sam Team 2 $186.00
Tom Team 2 $100.00

Above is an example of my data on Sheet 2. On Sheet 1, I want to total all
the total funds raised per Team shown on Sheet 2. I am trying to create a
summary of what each team raised.

I tried using the formula: =SUM(('sheet 2'!F2:F482=Sheet1!B2)) and I get
just a dash in my total col.

Can anyone provide some help?

Thanks

 

[Niek Otten]

Look in HELP for the SUMIF() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Col B Col C Col F
| Mary Team 1 $331.00
| George Team 1 $222.00
| Sam Team 2 $186.00
| Tom Team 2 $100.00
|
| Above is an example of my data on Sheet 2. On Sheet 1, I want to total all
| the total funds raised per Team shown on Sheet 2. I am trying to create a
| summary of what each team raised.
|
| I tried using the formula: =SUM(('sheet 2'!F2:F482=Sheet1!B2)) and I get
| just a dash in my total col.
|
| Can anyone provide some help?
|
| Thanks
|

 

[NeedHelpFast]

I had tried using help but did not find the answer. I found an old Excel book
by Que and found the formula that I need.

 

[Shane Devenshire]

Hi,

Your formula should look more like:

Assuming that you list team names in column B of sheet1 and the team names
are in column B of sheet2 also

=SUM(('sheet 2'!B$2:B$482=Sheet1!B2)*('sheet 2'!F$2:F$482)) this formula
would be array entered (Shift+Ctrl+Enter) or

=SUMPRODUCT(('sheet 2'!B$2:B$482=Sheet1!B2)*('sheet 2'!F$2:F$482)) not
array entered. There are other variations of this.

Cheers,
Shane Devenshire
Microsoft Excel MVP