vangogh228
Registered User.
- Local time
- Today, 07:08
- Joined
- Apr 19, 2002
- Messages
- 302
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!!
=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!!