Hi,

I'd like to be able to sum every n rows in a single array so the values are kept and can be multiplied separately?

Currently the only way I can see to sum every n rows uses 2 arrays which is shown below so the separate values are lost

=SUMPRODUCT(B1:B15,MOD(ROW(B1:B15)+0,2))