Formula calculation question

  • Thread starter Thread starter Phil Servedio
  • Start date Start date
P

Phil Servedio

I need to total up a set up computations based upon two columns. For
example:

A B
1] 1 24.00
2] 2 12.00
3] 1 5.00
4] [formula]

Cell 4B needs to be a formula of (A1*B1) + (A2*B2) + (A3+B3)...and so
on, for as many rows there are.

Is there an excel function or syntax shortcut that is simpler than
writing
the above "(A1*B1)+..." calculation?

-Phil
 
Phil

In cell B4, enter the formula:

=SUMPRODUCT((A1:OFFSET(A4,-1,,1)*(B1:OFFSET(B4,-1,,1))))

Regards

Trevor
 
Many thanks to all who contributed!

Domenic said:
Try,

=SUMPRODUCT(A1:A3,B1:B3)

Hope this helps!

I need to total up a set up computations based upon two columns. For
example:

A B
1] 1 24.00
2] 2 12.00
3] 1 5.00
4] [formula]

Cell 4B needs to be a formula of (A1*B1) + (A2*B2) + (A3+B3)...and so
on, for as many rows there are.

Is there an excel function or syntax shortcut that is simpler than
writing
the above "(A1*B1)+..." calculation?

-Phil
Click to expand...
Click to expand...
 
Back
Top