View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default 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,