May 12 2021 04:57 PM
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.