Salary for 80 employees broken out by month across 150 Sub-units

[murphd72]

Hi all,

Finishing off budgets and just been asked can I split out salary in an entirely new way. I am hoping that there is a way I don't know about.

Thanks

Dara

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1086"]
<tbody>[TR]
[TD]Employee[/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]Feb-18[/TD]
[TD="align: right"]Mar-18[/TD]
[TD="align: right"]Apr-18[/TD]
[TD="align: right"]May-18[/TD]
[TD="align: right"]Jun-18[/TD]
[TD="align: right"]Jul-18[/TD]
[TD="align: right"]Aug-18[/TD]
[TD="align: right"]Sep-18[/TD]
[TD="align: right"]Oct-18[/TD]
[TD="align: right"]Nov-18[/TD]
[TD="align: right"]Dec-18[/TD]
[TD][/TD]
[TD]Product A[/TD]
[TD]Prodcut B[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]4500[/TD]
[TD="align: right"]4400[/TD]
[TD="align: right"]4300[/TD]
[TD="align: right"]4200[/TD]
[TD="align: right"]4100[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]3900[/TD]
[TD="align: right"]3800[/TD]
[TD][/TD]
[TD="align: right"]25%[/TD]
[TD="align: right"]75%[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]3600[/TD]
[TD="align: right"]3350[/TD]
[TD="align: right"]3530[/TD]
[TD="align: right"]3710[/TD]
[TD="align: right"]3890[/TD]
[TD="align: right"]4070[/TD]
[TD="align: right"]4250[/TD]
[TD="align: right"]4430[/TD]
[TD="align: right"]4610[/TD]
[TD][/TD]
[TD="align: right"]50%[/TD]
[TD="align: right"]50%[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Plus another 20 employees[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 3"]What I am looking for is a way to get[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]Feb-18[/TD]
[TD="align: right"]Mar-18[/TD]
[TD="align: right"]Apr-18[/TD]
[TD="align: right"]May-18[/TD]
[TD="align: right"]Jun-18[/TD]
[TD="align: right"]Jul-18[/TD]
[TD="align: right"]Aug-18[/TD]
[TD="align: right"]Sep-18[/TD]
[TD="align: right"]Oct-18[/TD]
[TD="align: right"]Nov-18[/TD]
[TD="align: right"]Dec-18[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Product A[/TD]
[TD]=(B3*O3)+(B4*O4)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col span="14"></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[StephenCrump]

Welcome to the Forum!

Instead of =(B3*O3)+(B4*O4)

Try: =SUMPRODUCT(B3:B4,O3:O4)

Just adjust the row reference, 4, depending on the row number of your last employee.

 

[murphd72]

Welcome to the Forum!

Instead of =(B3*O3)+(B4*O4)

Try: =SUMPRODUCT(B3:B4,O3:O4)

Just adjust the row reference, 4, depending on the row number of your last employee.

Thanks Stephen. That worked great - now to try and develop it for when new employees and new jobs come on baord

 

[StephenCrump]

Thanks Stephen. That worked great - now to try and develop it for when new employees and new jobs come on baord

Great! Post back if you need any more help.