SUMIFS or SUMPRODUCT repeat formula for all occurrences of each employee

Hello again. I'm not exactly an Excel guru (although I seem to be working towards it, no matter how much I fight, lol) and hope one of you folks can help me out on this one.

Essentially, i have a worksheet that comes in and totals each expenditure for employees over the past few years. Some employees have multiple entries, some have only one. I've inserted two columns, one totaling expenditures in 2011, the other totaling expenditures in 2012. Each needs to total the expenditures for their year from a list of expenditures for each employee name. I have added a SUMIFS formula for the range of cells for the first name, and it works perfectly. However, I need this to apply to each instance of an employee name throughout the sheet, without having to manually enter the formula and new range for each employee. I can't use a pivot table, as the sheet has automatic subtotals incorporated. Not sure if I can do this with SUMIFS, or even SUMPRODUCT.

Here is the formula for the first name occurrence and the 2011 total:
=SUMIFS(E2:E6,C2:C6,">=1/1/2011",C2:C6,"<=12/31/2011")

Here is the forumla for the first name occurrence and the 2012 total:
=SUMIFS(E2:E6,C2:C6,">=1/1/2012",C2:C6,"<=12/31/2012")

As stated, both work fine, I just need a way to extend them down through the sheet and apply to whatever cells are under each employee name. I've attached a sample worksheet with representative data. Of course, I could go through each one manually, paste the formula, and change the range, but there are thousands of employees, and I really don't want to spend the next day or so doing nothing but this

Any help would be greatly appreciated.

Thank you.

Thanks for the post. But not quite what you have. I made some changes to the original worksheet. There are three "Total" columns, AP Payout (which has the total of expenditures for each employee, this field is already done, formulas were apparently entered manually by whomever created the spreadsheet), Total 2011, which will Total 2011 expenditures, and Total 2012. these are in the yellow rows totaled under each employee. I added the formula for the four employee examples. Unfortunately, these have to go in their own columns as in the attached worksheet. Unless I missed something in your update.

Basically, the end user doesn't want a pivot table, wants the yearly totals in columns next to the total payout.

I went ahead and gave them a pivot table. they aren't exactly happy, but are dealing with it. If anyone has any solution to add these as columns (other than copying, pasting, and editing the formula for each employee), please let me know. Thank you.

that's still a pivot table, and exactly what I gave them since they were pushy about getting it back. I do still need to try to find a way to put it into columns titled 2011 and 2012. thanks.

It could be I'm not being clear, trust me, that happens, lol.

The pivot table sums up what I need, I just need it to be in columns F and G in the second worksheet I attached. I.E., I need to have the Total 2011 and Total 2012 columns filled in in the same row as the (Employee Name) Total.

Your pivot table sums the data perfectly, it just isn't in the place on the worksheet where the head honchos want it to appear.

Hope that makes it more clear.

Still stuck on this. Anyone with input? I'd still like to be able to make the bosses happy and give them their data where they want it instead of in a pivot table.

Thanks to all.