Sum of the Multiplications of Two or more Dynamic Ranges
 

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

Sum of the Multiplications of Two or more Dynamic Ranges
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
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

Sum of the Multiplications of Two or more Dynamic Ranges
 

=SUMPRODUCT((Price)*(Qty))

should work


--
Greetings from New Zealand
wrote in message
oups.com...
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

Sum of the Multiplications of Two or more Dynamic Ranges
 

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.



wrote:

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

--

Dave Peterson