How to divide array formula?
hi, !
better if you write-down your array (say) to range [B2:M2]
and start with a formula like one of the following:
op1: =sumproduct(subtotal(9,offset($b$2,,row(a1)*3-3,,3)))
op2: =sum(index($b$2:$m$2,row(a1)*3-2):index($b$2:$m$2,row(a1)*3))
copy/drag down as needed
hth,
hector.
__ OP __
Hello every one,
I got this array:
{0,0,1,1,0,1,1,0,1,1,1,1}
Is there a way to SUM every 3 numbers?
Desired result:
SUM (0,0,1)
SUM (1,0,1)
SUM (1,0,1)
SUM (1,1,1)
It would return:
1
2
2
3
Thank you,
|