YEARLY TOTAL
 

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.

YEARLY TOTAL
 

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} & "!D1:D50")))

Does that get you started?
--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"mwise" wrote:

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.