How can I use SumProduct with a horizonontal and vertical array?

[issy]

With the SumProduct formula, the arrays must have the same dimensions. So how
can I use it when I want to sum the product of a horizontal row of data and a
vertical column of data? I've tried messing around with the Transpose
function but I can't get it to work with SumProduct.

Hi
Give us a clue as to what data you have where and what you want as a result
and we'll have a go!

Andy.

"issy" <[email protected]> wrote in message
news:[email protected]...
> With the SumProduct formula, the arrays must have the same dimensions. So
> how
> can I use it when I want to sum the product of a horizontal row of data
> and a
> vertical column of data? I've tried messing around with the Transpose
> function but I can't get it to work with SumProduct.

[Ardus Petus]

You can indeed use TRANSPOSE, but the whole furmula must be validated as
Array furmula (Ctrl+Shift+Enter):
=SUMPRODUCT(TRANSPOSE(B1:D1),A1:A3)

HTH
--
AP

"issy" <[email protected]> a écrit dans le message de news:
[email protected]...
> With the SumProduct formula, the arrays must have the same dimensions. So
> how
> can I use it when I want to sum the product of a horizontal row of data
> and a
> vertical column of data? I've tried messing around with the Transpose
> function but I can't get it to work with SumProduct.

[Dav]

I think you are half right. for a sumproduct to work the arrays need to be of equal length, one can be horizontal and one can be vertical so

sumproduct((a1:a4=1)*(b1:e1=1),a11:a14)

would evaluate as a sumproduct!

Regards

Dav