Try...

K27, copied down and across:

=SUM(MMULT(($D$6:$D$17=$D27)*($E$6:$E$17=TRANSPOSE ($E$21:$E$23)),$Q$21:$A
B$23)*($Q$6:$AB$17)*($F$6:$F$17)*($Q$2:$AB$2=K$2))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"Syed" wrote:

Thanks to those who replied to my post yesterday about multiplying several
tables based on certain criteria. However, Im still stumped in a few other
areas. Since it is somewhat of a complicated problem, I had to create a
spreadsheet to show it:
http://www.syedfaisal.com/TableMultProb.xls

I have a table containing number of units (rows 6:17) €“ each entry is
€œtagged€� with a Tower, a Source, and a cost per unit. I also have a table of
escalation factors for each Source (rows 21:23).

What I need to do is multiply the (number of units) x (cost per unit) x
(escalation factor appropriate to each Source), using ONLY the monthly units
and monthly escalation factors (blue cells only).

Ive tried to do the calculations for the various breakdowns Ill need on
rows 27:39 (the formula you posted is in Q27:AB29). However, I am unable to
figure out the formula for the cells in red. How can I calculate the red
cells using the data in the blue cells only?

Any thoughts on the formulae I'll need in cells K27, K39, and Q39?

Thanks in advance.