SUMPRODUCT Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

It doesn't look like I can get SUMPRODUCT to work on a vertical array and a
horizental array. For example, SUMPRODUCT(A2:A5, B6:E6) gives #VALUE!.
SUMPRODUCT(A2:A5, TRANSPOSE(B6:E6)) or SUMPRODUCT(TRANSPOSE(A2:A5), B6:E6))
also does not work.

I guess I can use MMULT(B6:E6, A2:A5), but does any one know how to get
SUMPRODUCT to work?

Thanks,
Geoffrey
 
Because of the Transpose function, you need to array-enter the formula --
ctrlshift/enter.
Bob Umlas
Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT does not work 3
Sumproduct not working 5
generate automatically sum 6
Count if formula error 5
Sumproduct 4
sum of blank cells returns zeros 7
sumproduct with multiple variables 8
Averaging blank or cells with Zeros in them. 4

Back
Top