=AVERAGE(LARGE(1:1,ROW(INDIRECT("1:"&MIN(COUNT(1:1 ),30)))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

This will cater for less than 30 entries in the row.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Capt Bill" wrote
in message ...

I need to average only the last 30 entrys in a row of data. Is thier a
way?


--
Capt Bill
------------------------------------------------------------------------
Capt Bill's Profile:
http://www.excelforum.com/member.php...o&userid=32850
View this thread: http://www.excelforum.com/showthread...hreadid=526652