Proton Sheets - does not support array-like indexing, example it does not have a way to dynamic skip rows automatically.
the formula for this is :
=SUMPRODUCT(CHOOSE(MOD(SEQUENCE(COUNTA(D10:D19))-1,2)+1, 4, 1), D10:D19)
to multiply odd elements by 4 before sum the product
=SUMPRODUCT(IF(ISODD(SEQUENCE(ROWS(D10:D19))), 4, 1), D10:D19)
or sum the product of two arrays but IF is not expanded to a array
Both should work but none do.
1
vote
pentiumvsamd
shared this idea