View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Holyhabanero
 
Posts: n/a
Default Adding then dividing

I want to compute how many file I close each month, then divide to see what
is my monthly average.

I currently do something like =SUM(I4:I7)/5 and then each month just replace
the last number with how many months have gone by, but is there a way to have
it just divide by the number of months without having to remember to change
the formula each month