Average last 6

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.

Hi David,

=AVERAGE(A65336:INDEX(A1:A65336,SUMPRODUCT(LARGE(ROW(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" <davidm.1spluc_1122267919.8414@excelforum-nospam.com> wrote in
message news:davidm.1spluc_1122267919.8414@excelforum-nospam.com...
>
> 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
>