Yes, I don't know where I got the last 10 values. <g
Must have been the subject.

--

Regards,

Peo Sjoblom

"Sandy Mann" wrote in message
...
Peo,

I may be reading the OP wrong - it wouldn't be the first time - but does
you
formula weight the last six games (three dates) as double value?

Making the named range "MyList" the *Game1Score* list and "RightList" the
*Game2Score* list and adapting your formula:


=(SUM(INDEX(MyList,COUNT(MyList)-9):INDEX(MyList,COUNT(MyList)))+SUM(INDEX(M

yList,COUNT(MyList)-2):INDEX(MyList,COUNT(MyList)))+SUM(INDEX(RightLis t,COUN

T(RightList)-9):INDEX(RightList,COUNT(RightList)))+SUM(INDEX(Ri ghtList,COUNT
(RightList)-2):INDEX(RightList,COUNT(RightList))))/10

does what I think the OP wanted namely averaging the last 10 sets of two
games with the last three game scores doubled.

Regards

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Peo Sjoblom" wrote in message
...
Use a named dynamic range


http://www.contextures.com/xlNames01.html#Dynamic


assyume it's named MyList

=AVERAGE(INDEX(MyList,COUNT(MyList)-9):INDEX(MyList,COUNT(MyList)))

or

=AVERAGE(OFFSET(MyList,COUNT(MyList)-1,,-10,))

the first is better since it's not volatile





--

Regards,

Peo Sjoblom


"Rob_B" wrote in message
...
Hi, I have a bowling spreadsheet that I list as:
Date Game1score Game2score

I want to be able to use a weighted average by averaging all scores,
but
for
the last 3 dates (6 games), weight them double.

Also, this will be a continually growing spreadsheet. How to I
calculate
averages so that it is only looking at the past 10 dates that it is
averaging. I do not want to average the entire sheet.

Thanks for any help.
Rob