Averaging blank cells

[Guest]

I am trying to set up a work sheet averaging the numbers in a colum that has
blank cells. I need to get the average of the filled in cells and as the
blank cells are filled in I need to have the average reflect the new
additions.


Thanks in advance

 

[Nick Hodge]

Scott

The worksheet function AVERAGE ignores blank cells

=AVERAGE(A1:A100)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Guest]

Use the average function; it will only consider numeric cells in the
calculation.
Ex: =average(a1:a10). If you entered 1 then 2 in a1 and a2, with the
remaining cells empty, the result is 1.5. When you then enter 3 in a3, the
result becomes 2.