Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Yearly Plan | Excel Discussion (Misc queries) | |||
yearly calendar | Excel Discussion (Misc queries) | |||
How can I create a running yearly total for all of my invoices? | Excel Worksheet Functions | |||
Yearly total average? | Excel Discussion (Misc queries) | |||
yearly invoice | Excel Worksheet Functions |