sum values #2-23 in a row help needed

[lost_in_the_sauce]

Pulled this from another thread and it works - =SUM(!Y7:INDEX(Y7:EZ7,SMALL(IF(Y7:EZ7<>0,COLUMN(Y7:EZ7)-COLUMN(Y7)+1),12)))
which gets me the sum of the first 12 numbers once a non-zero shows up.

However, I'm looking at growth rates so I want to include the first value, I'd like 2-13, and 14-25, etc.

Other issue is that if a series of numbers has blanks to the right side of it, it gives me an error that I could ignore with an IFERROR but I'd rather sum what was there

 

[StephenCrump]

Can you please provide an example to illustrate? It's not at all clear what the question is, when you variously describe your requirements as:

sum values #2-23 in a row​

I want to include the first value
I'd like 2-13, and 14-25, etc.
I'd rather sum what was there

 

[Peter_SSs]

Pulled this from another thread and it works - =SUM(!Y7:INDEX(Y7:EZ7,SMALL(IF(Y7:EZ7<>0,COLUMN(Y7:EZ7)-COLUMN(Y7)+1),12)))

Cannot see how it would work as it is not a valid formula syntax.