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
|