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: CP on 6 Mar 2010 12:21 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
From: Russell Dawson on 6 Mar 2010 12:41 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
From: CP on 6 Mar 2010 13:24 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
From: Teethless mama on 6 Mar 2010 13:24 =SUMPRODUCT(C1:C3,$E$1:$E$3) copy across "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
From: Roger Govier on 7 Mar 2010 04:43
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 |