Quote Originally Posted by Max, Singapore View Post
Try SUMIF
Assume your source data in Sheet1, IDs in col A, values in col B
In the other tab, you have IDs running in A2 down
Put in B2: =SUMIF(Sheet1!A:A,A2,Sheet1!B:B)
Copy down
--------
Success? Wave it, hit the little star at the bottom left of my response
This works but does the same as the vlookup a I have in there? Would it be a more efficient calculation and keep file size down?

What I was after was a formula that did those individuals calculations and summed all the values all in one cell.