Adding then dividing

H

Holyhabanero

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
 
V

vezerid

First of all the specific example you site is wrong. It divides a total
of 4 months by 5. Onto your question...

=AVERAGE(I4:I15)

will correctly calculate the average of the 12 cells, even if the later
months are still blank.

Does this help?
Kostis Vezerides
 
B

Bob Phillips

Do you have the dates stored anywhere so that you could just calculate the
months? you would also need a rule, for instance is 12 Jan to 3 Mar 1, 2 or
3 months?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
H

Holyhabanero

That worked great! Thanks so much for the help. (for some reason Excel
colored the corner of the cell to tell me something is wrong with the
formula, but it is working just fine, so I've ignored it.)
 
Top