View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default 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