Hi David,

=AVERAGE(A65336:INDEX(A1:A65336,SUMPRODUCT(LARGE(R OW(1:65336)*(A1:A65336<""
),6))))

although you wont want many of these in your spreadsheet <g

--

HTH

RP
(remove nothere from the email address if mailing direct)


"davidm" wrote in
message ...

Just curious. How can Bob's formula be tweaked to handle a generic
situation where* the last 6 rows in Column A* are always averaged.


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=389720