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))}
Bookmarks