View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Guntars Guntars is offline
external usenet poster
 
Posts: 22
Default How to divide array formula?

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,
Guntars