software

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

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 VezeridesDo 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)

quot;Holyhabaneroquot; gt; wrote in message
...
gt; I want to compute how many file I close each month, then divide to see
what
gt; is my monthly average.
gt;
gt; I currently do something like =SUM(I4:I7)/5 and then each month just
replace
gt; the last number with how many months have gone by, but is there a way to
have
gt; it just divide by the number of months without having to remember to
change
gt; the formula each month
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.)

quot;vezeridquot; wrote:

gt; First of all the specific example you site is wrong. It divides a total
gt; of 4 months by 5. Onto your question...
gt;
gt; =AVERAGE(I4:I15)
gt;
gt; will correctly calculate the average of the 12 cells, even if the later
gt; months are still blank.
gt;
gt; Does this help?
gt; Kostis Vezerides
gt;
gt;