Vlookup Sumif Forumla

[MROMAR]

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?

[NBVC]

Use SUMIFS

e.g.

=SUMIFS($E$1:$E$23600,$C$1:$C$23600,T6,$D$1:$D$23600,U3)

[MROMAR]

Use SUMIFS

e.g.

=SUMIFS($E$1:$E$23600,$C$1:$C$23600,T6,$D$1:$D$23600,U3)

Didn't seem to work for me, I noticed the formula doesn't refer to U5 which contains the month.

[MROMAR]

Oops forgot to mention Column F of the "Data" tab contains the dollar amounts that need to be summed up

[NBVC]

Try it as:

=SUMIFS(Data!$F$1:$F$23600,Data!$C$1:$C$23600,T6,Data!$D$1:$D$23600,U5,Data!$E$1:$E$23600,U3)

[MROMAR]

Try it as:

=SUMIFS(Data!$F$1:$F$23600,Data!$C$1:$C$23600,T6,Data!$D$1:$D$23600,U5,Data!$E$1:$E$23600,U3)

Thanks a lot!