If it works, the OP should like it :-)

Regards

Bob


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

As I said to Peo, I may be wrong but the way that I read it, your formula
does not do what the OP wants, namely average the last 10 sets of two
games
with the final 3 sets of two game score doubled.

Adapting your formula, I think that the array formula:


=(SUM(IF(A1:A31=LARGE(A1:A31,{1,2,3,4,5,6,7,8,9,10 }),B1:B31,0))+SUM(IF(A1:A3

1=LARGE(A1:A31,{1,2,3}),B1:B31,0))+SUM(IF(A1:A31=L ARGE(A1:A31,{1,2,3,4,5,6,7
,8,9,10}),C1:C31,0))+SUM(IF(A1:A31=LARGE(A1:A31,{1 ,2,3}),C1:C31,0)))/10

does what the OP wants but I can't say that I like it.

Regards

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


"Bob Phillips" wrote in message
...
Rob,

Assuming dates in A1:A20, scores in B1:B20, the last 10 scores can be
obtained with

=AVERAGE(IF(A1:A20=LARGE(A1:A20,{1,2,3,4,5,6,7,8,9 ,10}),B1:B20))

--

HTH

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


"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