a | b | c | d | e | f | g | h | i | |
1 | Tom | 21 | matt | larry | randy | tom | 135 | ||
2 | Bill | 12 | |||||||
3 | john | 23 | |||||||
4 | Larry | 76 | |||||||
5 | Randy | 32 | |||||||
6 | Lebron | 15 | |||||||
7 | Stan | 22 | |||||||
8 | Ben | 31 | |||||||
9 | Matt | 6 |
This is a small sample of the data i have in column a and b there may be 250 entries and the same in column e through h. I am wanting to add up the data from column b based on the entries in row e1 through i1. What would be the fastest formula to look up the values of matt(6)+larry(76)+Randy(32)+Tom(21) for a total of 135
Thanks
Adam