Thread: Finding Average of last 5 entries
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Finding Average of last 5 entries
Hello,

...
What should happen if there aren't at least 5 scores?
...

Does not matter. Array-enter
=AVERAGE(SMALL(A1:A99,ROW(INDIRECT("1:"&MIN(COUNTA (A1:A99),4)))))

Regards,
Bernd
Reply With QuoteReply With Quote