YEARLY TOTAL

[mwise]

I have a spreadsheet that list all employees, the amount they contribute to
401k that month and how much we match. There is a different worksheet for
each month, and because we have new employees all the time the row that the
employee is on changes each month. I need a way to get total contribution
for the year, and total match for the year for each individual employee.

 

[JBeaucaire]

A "trick" formula I use for 3-dimensional SUMIF() looks like this...my sheets
are named sequentially which is what makes this work:

=SUM(SUMIF(INDIRECT("Sheet"&{1,2,3} & "!B1:B50"), "=" & "Adam West",
INDIRECT("Sheet"&{1,2,3} & "!D150")))

Does that get you started?