RickMoore, do the blanks intersperse amongst data set ?

No:

=AVERAGE(INDEX(C4:AB4,MATCH(9.99999999999999E+307, C4:AB4)-3):AB4)

Yes:

=AVERAGE(INDEX(C4:AB4,LARGE(IF(ISNUMBER(C4:AB4),CO LUMN(C4:AB4)),MIN(4,COUNT(C4:AB4))):AB4)
confirmed with CTRL + SHIFT + ENTER


--
DonkeyOte
------------------------------------------------------------------------
DonkeyOte's Profile: http://www.thecodecage.com/forumz/member.php?userid=231
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123395