Populate Cell based on two criteria

[her.rockstar]

I have a list of teams, and beside them I need a calculation to be filled.

The criteria is based on a cell reference (a month which can be changed from a drop-down in BM2) and also the name of the team.

dummy 16.xls

[jeffreybrown]

In G14 copied down...

=SUMIF(Data!$R$2:$R$11,$F14,INDEX(Data!$C$2:$N$11,,MATCH($BM$2,Data!$C$1:$N$1,0)))

[her.rockstar]

That was painless! Thanks so much

[jeffreybrown]

You are very welcome and thanks for the feedback (and 'rep').

[Winon]

@ jeffreybrown,

Very good!

[jeffreybrown]

@Winon,

Thanks