Help with an additing calculation
in [General]
|
Prev: can I use conditional formating with result be hiding a row?
Next: How do I insert a timer in an excel worksheet?
From: Roger Govier on 7 Mar 2010 04:51 Apologies, hit the send button too soon for column E =SUMPRODUCT(C2:C40*E2:E30) for column D =SUMPRODUCT(C2:C40*D2:D40) -- Regards Roger Govier Roger Govier wrote: > Hi > > =SUMPRODUCT(C2:C40*E2:E40) > -- > Regards > Roger Govier > > CP wrote: >> That works - however it was a small example some of my columns are 40 >> lines long, I was wondering if there is another way? >> >> "Russell Dawson" wrote: >> >>> In C5 >>> =SUM($E2*C2)+($E3*C3)+($E4*C4) >>> In D5 >>> =SUM($E2*D2)+($E3*D3)+($E4*D4) >>> >>> >>> -- >>> Russell Dawson >>> Excel Student >>> >>> Please hit "Yes" if this post was helpful. >>> >>> >>> "CP" wrote: >>> >>>> I am trying to create a calcualtion for the following >>>> >>>> A B $ $ Qty >>>> Text Text 10 15 3 >>>> Text Text 5 6 >>>> Text Text 2 1 2 >>>> >>>> 34 47 >>>> >>>> so give a total of column C and D using E as a multiplier >>>> Any help greatly received > > > __________ Information from ESET Smart Security, version of virus > signature database 4921 (20100306) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > > > > __________ Information from ESET Smart Security, version of virus > signature database 4921 (20100306) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > |