Dropdown options turning into a multiplcation - financial modelling

[crackers85]

Hi there,

Would really appreciate some help with some formulas I am trying to create. I have already done up some dropdowns with new staff (different roles and wages) working into wages but there will also be additional costs i would like to total separately (phone, travel, software, hardware, etc.)
I would like to calculate these costs based on their month start. Any help would be greatly appreciated. I have attached a very simple spreadsheet diagram with some dummy figure included.

Any help would be greatly appreciated.

 

[ChrisFoster]

It sounds to me like you need to use the SUMIFS formula.

Try this in Cell F2 - this will sum C16 downwards if B16 downwards is 'March'.

=SUMIFS($C$17:$C$1048576,$B$17:$B$1048576,B2)

 

[crackers85]

It sounds to me like you need to use the SUMIFS formula.

Try this in Cell F2 - this will sum C16 downwards if B16 downwards is 'March'.

=SUMIFS($C$17:$C$1048576,$B$17:$B$1048576,B2)

Thanks for your help Chris.

I already use drop downs to calculate wages for the year. If a certain job role is selected, e.g. Head of Business starting March how can i then get monthly costs (separately) to populate in another tab?
e.g if HOB starting in March, the £50 would appear in each cell (months) on a different tab?

 

[crackers85]

so after working a bit myself i have the following formula which isnt quite right:
=INDEX(' New Roles'!$E$2:$E$8,MATCH('Wages 2021'!$A$49:$A$76,' New Roles'!$A$2:$A$8,0))*(13-MATCH('Wages 2021'!$B$49:$B$76,' New Roles'!$D$2:$D$13,0))
i want the new costs to add up when i select new staff, but this puts each new one separately in a new cell beneath one another. any ideas?