Sum of the Multiplications of Two or more Dynamic Ranges

[ongco1819]

Hi,

I was wondering if anyone cld help me out on formulas to be used in
Excel. The specifics are I hve defined two Dynamic Ranges say Price
and Qty and I want to Sum the product of these two Dynamic Ranges into
a cell. I thought using Array formula Ctrl Shift Enter on
=Sum(Price*Qty) should give me the required sum but instead it gives
me the following error msg #VALUE! How do I achieve my objective which
is to get the sum of the product from both these Dynamic Ranges, Price
and Qty.

Thank u in advance 4 yr help.

Cheers

 

[Bernard Liengme]

With =Sum(Price*Qty) you need to commit it with CTRL+SHIFT+ENTER as it is an
array formula
But more simply, you could use the non-array formula
=SUMPRODUCT(Price,Qty)
best wishes

 

[Bill Kuunders]

=SUMPRODUCT((Price)*(Qty))

should work

 

[Dave Peterson]

Maybe your ranges aren't equal size?

Maybe you have #value in one of the cells in either of the ranges?

There's another function that was made for this kind of thing:
=SUMPRODUCT(Price,Qty)

You don't need ctrl-shift-enter to enter it.