Warning: Trying to access array offset on value of type null in /www/wwwroot/app-pack.telkomuniversity.ac.id/wp-content/themes/sinrato/functions.php on line 40
Re: Sumproduct
With SUMPRODUCT the array arguments must have the same dimensions. You are trying to multiply and sum an arrays of 9×9 with on of 1×9 and one of 9×1. 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))
With SUMPRODUCT the array arguments must have the same dimensions. You are trying to multiply and sum an arrays of 9×9 with on of 1×9 and one of 9×1. 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))
