Hi,
I'm running into some trouble. I have multiple pages in a spreadsheet that I am trying to summarize. Here's the setup:
Sheet 1
A B C D
Location 1 Team 1 Stat 1 [sum from sheet 3]
Stat 2 [sum from sheet 3]
Stat 3 [sum from sheet 3]
Stat 4 [sum from sheet 3]
Location 1 Team 2 Stat 1 [sum from sheet 3]
Stat 2 [sum from sheet 3]
Stat 3 [sum from sheet 3]
Stat 4 [sum from sheet 3]
Sheet 2
A B C
Name Location Team
Sheet 3
A B C D E
Name Stat 1 Stat 2 Stat 3 Stat 4
On Sheet 1 in column D I am trying to pull up a sum of values based on the following criteria:
A sum of Stat 1 from Sheet 3 if the Name on Sheet 3 matches the Name and Team listed on Sheet 2.
Sheet 2 contains a very large list of names with entries for Location and Team. I'm trying to add up a specific statistic for each agent on a particular team and get a total. The names and team assignments on on Sheet 2, the data on Sheet 3, and the finished sum goes on Sheet 1.
Any ideas how to accomplish all of this? I can't quite get SumProduct to work for me in this case.
-Tom
Bookmarks