YEARLY TOTAL

  • Thread starter Thread starter mwise
  • Start date Start date
M

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.
 
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?
 
Back
Top