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

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

<tbody>
</tbody>

 

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