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
|