View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
issy
 
Posts: n/a
Default 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.