=AVERAGE(INDEX(1:1,,SUMPRODUCT(LARGE(COLUMN(1:1)*( 1:1<""),1))):INDEX(1:1,,SUMPRODUCT(LARGE(COLUMN(1 :1)*(1:1<""),6))))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Phil H." wrote in message
...
I am looking to create a function to only average the last 6 entries in a
list of numbers w/out changing the target cells of the AVERAGE function on
a
monthly bases.
Example: I want to track scores on a monthly bases but only want the
average
of the last six months worth of scores.