Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use SumProduct with a horizonontal and vertical array?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use SumProduct with a horizonontal and vertical array?
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use SumProduct with a horizonontal and vertical array?
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" a écrit dans le message de news: ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use SumProduct with a horizonontal and vertical array?
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 -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=545408 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|