I'm failing to come up with a SUMIF INDEX MATCH formula. I want to MATCH a name in Column P to Column B and SUM up the two totaled cells in Column L to go in Column R. (The sources of the rows are indexed from other worksheets). So Tom G would get a 102 value in R3. Brian would get a 110 and so on. Even though these are name lists are aligned, they won't be on other sheets. So I need to INDEX and MATCH the names.
I've tried various =SUMIF… INDEX MATCH… But can't figure how to give instructions to add the two cells at the end of the player's column. Any help is greatly appreciated!
I've tried various =SUMIF… INDEX MATCH… But can't figure how to give instructions to add the two cells at the end of the player's column. Any help is greatly appreciated!
INDEX-MATCH-SUM.xlsx | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
1 | IndianMound | ||||||||||||||||||||
2 | Tom G | IndianMound | |||||||||||||||||||
3 | Score | 4 | 2 | 5 | 3 | 3 | 2 | 4 | 3 | 3 | 48 | Tom G | |||||||||
4 | Score | 5 | 9 | 5 | 8 | 6 | 4 | 5 | 4 | 8 | 54 | Brian A | |||||||||
5 | Jody B | ||||||||||||||||||||
6 | Brian A | Wally B | |||||||||||||||||||
7 | Score | 5 | 3 | 8 | 4 | 7 | 5 | 6 | 6 | 5 | 49 | Rich C | |||||||||
8 | Score | 7 | 8 | 7 | 8 | 6 | 5 | 6 | 7 | 7 | 61 | Joel C | |||||||||
9 | Jim G | ||||||||||||||||||||
10 | Jody B | Ray L | |||||||||||||||||||
11 | Score | 8 | 3 | 8 | 6 | 6 | 9 | 3 | 10 | 5 | 58 | Jay M | |||||||||
12 | Score | 7 | 8 | 7 | 8 | 6 | 5 | 6 | 7 | 7 | 61 | Mark M | |||||||||
13 | Ken R | ||||||||||||||||||||
14 | Wally B | Mike S | |||||||||||||||||||
15 | Score | 8 | 5 | 6 | 8 | 8 | 6 | 7 | 7 | 4 | 59 | Steven S | |||||||||
16 | Score | 5 | 6 | 5 | 5 | 7 | 5 | 4 | 6 | 7 | 50 | Rob T | |||||||||
17 | Dean V | ||||||||||||||||||||
18 | Rich C | Bruce W | |||||||||||||||||||
19 | Score | 5 | 5 | 5 | 4 | 7 | 7 | 4 | 9 | 4 | 50 | ||||||||||
20 | Score | 5 | 6 | 5 | 4 | 4 | 5 | 3 | 5 | 5 | 42 | ||||||||||
21 | |||||||||||||||||||||
22 | Joel C | ||||||||||||||||||||
23 | Score | 7 | 4 | 7 | 9 | 6 | 8 | 3 | 8 | 3 | 55 | ||||||||||
24 | Score | 6 | 6 | 8 | 5 | 6 | 5 | 6 | 5 | 5 | 52 | ||||||||||
25 | |||||||||||||||||||||
26 | |||||||||||||||||||||
27 | |||||||||||||||||||||
28 | |||||||||||||||||||||
29 | |||||||||||||||||||||
Sheet1 |