Average range from a different point on each row based on a value

[Brandi]

I have been asked to give a 30-60-90-120 day average on daily production numbers for each "person", but starting from the first day they started actually producing.
I am working with a years' worth of data, but for the example I have narrowed it to 10 days. So, basically I want to start from the first non-zero cell and get, let say, a 3 day average.

I was trying to use the following formula:

=AVERAGE((CELL("address",INDEX(B2:K2,MATCH(TRUE,INDEX(B2:K2<>0,),0)))):(CELL("address",OFFSET(INDEX(B2:K2,MATCH(TRUE,INDEX(B2:K2<>0,),0)),0,2))))

And now I am not able to upload the sample file I created!

It would be just a basic table of column one with names and headers are dates.

I am trying to create the cell reference range from the first non-zero cell and then average the next 3 cells.

Any help would be much appreciated.
Thank You,
Brandi

 

[Brandi]

Here is my formula again, I was getting emoticons in it, so I used the code post. I think that makes it hard to read.

=AVERAGE((CELL("address",INDEX(B2:K2,MATCH(TRUE,INDEX(B2:K2<>0,),0)))) : (CELL("address",OFFSET(INDEX(B2:K2,MATCH(TRUE,INDEX(B2:K2<>0,),0)),0,2))))