Help with an additing calculation
 

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

Help with an additing calculation
 

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

Help with an additing calculation
 

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

Help with an additing calculation
 

=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

Help with an additing calculation
 

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

Help with an additing calculation
 

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