0

I have a SUMPRODUCT equation that works fine on one row:

=SUMPRODUCT(O4:O10-O3:O9,E2-P4:P10,N(E2>P4:P10))

However, instead of copying it for each E row I want to use ARRAYFORMULA to automatically generate the values using E2:E.

When I try the following:

=ARRAYFORMULA(SUMPRODUCT(O4:O10-O3:O9,E2:E-P4:P10,N(E2:E>P4:P10)))

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.

  • share a copy of your sheet pls – user0 Jun 3 at 21:49
0

The error is caused by this part

E2:E-P4:P10

The end part in E2:E is an open reference, meaning that it will be take the last row of the sheet.

One possible solution could be to change E2:E by E2:E8 or something similar in order to make this part of the formula have the same number of rows as P4:P10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.