The blank cells can be any place in the row There can can be any number of
blank cells between entries. Some rows have only 1 entry others have 20 with
any number of blank cells in between.
I tried entering the formula from below
=AVERAGE(INDEX(C4:AB4,LARGE(IF(ISNUMBER(C4:AB4),CO LUMN(C4:AB4)),MIN(4,COUNT(C4:AB4))):AB4)
I got an excel message box that formula had an error. I copied it from your
reply, so it should be entered as you wrote it. I did enter it by using the
ctrl+shift+enter
I have been looking for a solution for years, I hope you can Help
Thanks
--
Rick


"DonkeyOte" wrote:


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