Hi!

How is the data layed out? Down a column? Across a row? Are there any blank
cells in the range? Any zeros? What if there aren't 20 scores?

Biff

"Phineus" wrote in message
...
I'm trying to set up an excel spreadsheet to calculate my handicap. The
tricky part, for me anyway, is I need to average the 10 best scores out of
the last 20 played. Any idea? Thanks.