Forum Discussion
Sumproduct
Hello,
I keep getting a #Value error with a simple Sumproduct formula.
What am I doing wrong? Does the order of the arrays matter?
Thank you.
2 Replies
If with SUMPRODUCT()
=SUMPRODUCT( Source!$H$13:$P$21, MMULT(--(Source!$C$13:$C$21=$D12), --(Source!$H$9:$P$9=G$10)) )With SUMPRODUCT the array arguments must have the same dimensions. You are trying to multiply and sum an arrays of 9x9 with on of 1x9 and one of 9x1. Hence, #VALUE!
Perhaps the following formula in G12 does what you need. Copy down and across.
=INDEX(Source!$H$13:$P$21,MATCH($D12,Source!$C$13:$C$21,0),MATCH(G$10,Source!$H$9:$P$9,0))
