View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phil H. Phil H. is offline
external usenet poster
 
Posts: 16
Default Automaticly changing average function target cells

I am looking to create a function to only average the last 6 entries in a
list of numbers w/out changing the target cells of the AVERAGE function on a
monthly bases.
Example: I want to track scores on a monthly bases but only want the average
of the last six months worth of scores.