I have a
SUMPRODUCT equation that works fine on one row:
However, instead of copying it for each
E row I want to use
ARRAYFORMULA to automatically generate the values using
When I try the following:
I get the error
Array arguments to MINUS are of different size.
I know there is another question asking something similar, but there is no explanation of the formula in the answer so I cannot apply it to my situation easily.