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.
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))