Average formula that starts at first cell>0 and calculates blank cells as 0?

Basically, I’m trying to combine this formula that captures the first value above zero, but ignores blank cells:

IF(MAX($B5:$M5),AVERAGE(INDEX($B5:$M5,MATCH(TRUE,INDEX($B5:$M5>0,0),0)):$M5),"")

With this array formula that counts blank cells as zeroes:

{=AVERAGE(IF(B5:M5,B5:M5,B5:M5))}

Have you tried AVERAGEA ? if does ignores blank or text cells

I want to include blank cells as zero values. I don't think AVERAGEA works in this case.

I need to take the aspect of the second formula that recognizes blank cells as zero and incorporate it into the first formula. Ultimately, I want to have an average of the cells after the first value > 0 that includes blank cells as 0 in the average.

Lets Take a structured approach to this

First determine which row contains the first cell >0 -> Beg Cell
Then determine how many rows are "used" -> Ending Cell

=Average(INDIRECT(Beg Cell&":"&Ending Cell))

RCM, that was the way to go. Here's what I came up with:

=SUM(B5:M5)/(12-(MATCH(TRUE,LEN(B5:M5)<>0,0)))

Thanks so much for your help. I think I was making this way too complicated.

glad I could help Bradtredo, Happier Holydays !!!! (now that you solved your inquiry)