Adding then dividing
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
|