Multiple Column Validation to SUM by Months

[winderkent]

Hi everyone,

I am in need of some help with the following and appreciate if any of you could help on this. Very much appreciated.

Column G, H, I and J are a drop down list which I could simply select the Staff names and the row will adjust the Total Staff Costs accordingly.

Column K which is "Total Staff Cost" would be to tabulate whatever is selected in Column G, H, I and J based on the Months.

So for example Jan-17, Staff Costs amount up to $26,515.60 while Sep-17, Staff Costs amount up to $18,551.15

https://www.dropbox.com/s/fkqzb7v8do4xv2t/Excel_Problem.png?dl=0

Appreciate your kind help. Much appreciated. Thank you!

 

[mart37]

place all data in one table and use a pivottable