Hi,

I need a formula that would tabulate the total of a certain cost driver in a certain city based on a certain month

In Cell T6 I have the city, Cell U3 contains a Cost driver that I can selcect from a drop down list so its going to change. Cell U5 contains the Month

I have a table array in a tab called "Data" from A1-U23600

I have the cities in column C of the data, month in column D, the Cost Driver in column E.

I need the formula to return the total cost of a cost driver of a certain city in a certain month, and if I change any one of those factors it should change automatically.

I think it's a combination of Vlookup and Sumif, but I'm not sure.

Any suggestions?