How do I shorten This monstrosity?
Posted by Al on December 30, 2001 4:06 PM
Is there any way to shorten this
=SUM(AG227*$AM$102)+(AG228*$AM$104)+(AG229*$AM$103)+
(AG230*$AM$105)+(AG231*$AM$107)+(AG232*$AM$106)+
(AG233*$AM$132)+(AG234+$AM$134)+(AG235*$AM$133)+
(AG236*$AM$132)+(AG237*$AM$134)+(AG238*$AM$133)+
(AG239*$AM$132)+(AG240*$AM$134)+(AG241*$AM$133)+
(AG242*$AM$132)+(AG243*$AM$134)+(AG244*$AM$133)+
(AG247*$AM$135)+(AG248*$AM$134)+(AG249*$AM$136)+
(AG250*$AM$108)+(AG251*$AM$110)+(AG252*$AM$109)+
(AG253*$AM$111)+(AG254*$AM$113)+(AG255*$AM$112)+
(AG256*$AM$114)+(AG257*$AM$116)+(AG258*$AM$115)+
(AG259*$AM$120)+(AG260*$AM$122)+(AG261*$AM$121)+
(AG262*$AM$123)+(AG263*$AM$125)+(AG264*$AM$124)+
(AG265*$AM$126)+(AG266*$AM$127)+(AG267*$AM$128)+
(AG268*$AM$129)+(AG269*$AM$131)+(AG270*$AM$130)+
(AG272*$AM$117)+(AG273*$AM$119)+(AG274*$AM$118)
believe it or not, this works
AL
Posted by IML on December 31, 2001 10:11 AM
Have a look if Sumproduct would work for you. The format would be along the lines of
=SUMPRODUCT(A1:A15,B1:B15)
to multiply then add the sums of A1:B15
Posted by AL on December 31, 2001 12:28 PM
Re: Thanks, I'll try it
