May 12 2021 04:57 PM
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.
May 12 2021 09:14 PM
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))
May 13 2021 02:20 AM
If with SUMPRODUCT()
=SUMPRODUCT(
Source!$H$13:$P$21,
MMULT(--(Source!$C$13:$C$21=$D12),
--(Source!$H$9:$P$9=G$10))
)