Help with an additing calculation

  • Thread starter Thread starter CP
  • Start date Start date
C

CP

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
 
That works - however it was a small example some of my columns are 40 lines
long, I was wondering if there is another way?
 
Apologies, hit the send button too soon
for column E
=SUMPRODUCT(C2:C40*E2:E30)
for column D
=SUMPRODUCT(C2:C40*D2:D40)
 
Back
Top