SUM with INDEX MATCH

[beckys]

I have a spreadsheet containing data in cells Data!F2:BB373.
There are row titles in cells Data!F1:BB1
There is identifing information in cells Data!B2:B373 and Data!E2:E373.

I would like to do the following:

Sum up the data in cells Data!F2:BB373
When Data!F1:BB1 = C$1
When Data!B2:B373 = $B4
When Data!E2:E373 = $A4

Any Suggestions?

Thanks much!

 

[T. Valko]

I have a spreadsheet containing data in cells Data!F2:BB373.
There are row titles in cells Data!F1:BB1
There is identifing information in cells Data!B2:B373 and Data!E2:E373.

I would like to do the following:

Sum up the data in cells Data!F2:BB373
When Data!F1:BB1 = C$1
When Data!B2:B373 = $B4
When Data!E2:E373 = $A4

Any Suggestions?

Thanks much!

Try this...

=SUMPRODUCT((Data!F1:BB1=C1)*(Data!B2:B373=B4)*(Data!E2:E373=A4)*Data!F2:BB373)

 

[Jonmo1]

Try

=SUMPRODUCT((Data!F1:BB1=C$1)*(Data!B2:B373=$B4)*(Data!E2:E373=$A4)*(Data!F2:BB373))

 

[beckys]

Great! Thanks much!