View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joewis joewis is offline
external usenet poster
 
Posts: 1
Default Average of last 3 non-0 numbers in row?

I am secratary of golf league and handicap is calculated of the average of
the last 3 rounds played. If a player is absent for a week, there is a zero
in his score. This would be a rolling average of coarse.