Help on averaging a list

[Lento Yip]

Hi experts,

This is for calculation of bowling averages.

There is a variable length list of numbers in a row (score history of a
bowler, new scores appended to the end).

What are the functions to find:

1. the average of the last 21 numbers
2. Filter the scores that were above 150, then calculate the average of the
last 21 of the filtered list

Million thanks!!

(e-mail address removed)

 

[Guest]

If your scores are in column A then:

=AVERAGE(OFFSET(A1,MATCH(2,1/(A1:A65535<>0))-1,,-21))

This is an array formula and must be entered with a CNTRL-SHFT-ENTER

The same type of formula can be used on a filtered list.
--
Gary's Student
gsnu200701

Hi experts,

This is for calculation of bowling averages.

There is a variable length list of numbers in a row (score history of a
bowler, new scores appended to the end).

What are the functions to find:

1. the average of the last 21 numbers
2. Filter the scores that were above 150, then calculate the average of the
last 21 of the filtered list

Million thanks!!

(e-mail address removed)



---