Can someone help me with some adjustments with this formula that I found in a
search? I need the formula to average the last three entries in a row, which
it does...it even does an average if there are less than three.. which is
also what I want. But I get an error when there are zero numbers which is
what I want to get ride of. I found two other suggestions in my search but I
cannot get them to work.
=AVERAGE(INDEX(A4:H4,LARGE(COLUMN(A:Z)*(ISNUMBER(A4:H4)),3)):AB4)
This one works perfectly except I get an error if there are no entries. I
found the follow two formulas that claim to eliminate the problem but do not
seem to work:
=IF(COUNT(A4:H4)=0,"",AVERAGE(INDEX(A4:H4,LARGE(COLUMN(A:Z)*(ISNUMBER(A4:H4)),4)):H4))
=IF(COUNT(A4:H4),AVERAGE(INDEX(A4:H4,LARGE(COLUMN(A:Z)*(ISNUMBER(A4:H4)),3)):H4),"NEED DATA")
Thanks,
--
Mike Mast
Special Education Preschool Teacher