YEARLY TOTAL

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.
 
J

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

Does that get you started?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top