View Full Version : Any help in simplifying a sum of sumproducts


vangogh228
11-01-2006, 10:30 AM
I have this (new line at commas for clarity:

=SUM(
A14*SUMPRODUCT($E$12:$L$12,E14:L14),
A15*SUMPRODUCT($E$12:$L$12,E15:L15),
A16*SUMPRODUCT($E$12:$L$12,E16:L16),
A17*SUMPRODUCT($E$12:$L$12,E17:L17),
A18*SUMPRODUCT($E$12:$L$12,E18:L18),
A19*SUMPRODUCT($E$12:$L$12,E19:L19),
A20*SUMPRODUCT($E$12:$L$12,E20:L20),
A21*SUMPRODUCT($E$12:$L$12,E21:L21),
A22*SUMPRODUCT($E$12:$L$12,E22:L22),
A23*SUMPRODUCT($E$12:$L$12,E23:L23),
A24*SUMPRODUCT($E$12:$L$12,E24:L24),
A25*SUMPRODUCT($E$12:$L$12,E25:L25)
)

And would like to simplify it. Help? THANKS!!

shades
11-07-2006, 08:51 AM
Howdy. Sorry for the delay. Work has been wildly hectic.

Try this:

=SUMPRODUCT(($E$12:$L$12)*($E14:$L25)*($A$14:$A$25 ))