Excel Formula Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am trying to find the best was to do the following:
A B

1 5

3 10

5 15

I only want a sum of above if there is a number in the A column
i.e. (1*5) + (3*10) + (5*15)

What is the best way to do this considering the data is going to be changing
all the time.

Please advise as soon as possible.
Thanks

MM
 
This is an easy one. Try this:

=SUMPRODUCT((A1:A10),(B1:B10))

If you have any text in those columns, it will need to be tweaked.
 
Great, it works fantastically.

Barb Reinhardt said:
This is an easy one. Try this:

=SUMPRODUCT((A1:A10),(B1:B10))

If you have any text in those columns, it will need to be tweaked.
Click to expand...
 
Back
Top