Excel Formula Help

[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

 

[Guest]

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.

 

[Guest]

Great, it works fantastically.

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.