Hi Milo,

Am Sun, 7 Apr 2013 15:44:28 +0200 schrieb Claus Busch:

you can use the greatest range e.g. C2:C32
Empty cells will be ignored

have a look in the help for AVERAGE
Text and empty cells will be ignored.
You only would get a wrong result, if there are zeros in the cells
below.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2