Averaging blank cells
 

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

Averaging blank cells
 

Scott

The worksheet function AVERAGE ignores blank cells

=AVERAGE(A1:A100)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Scott W" wrote in message
...
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

Averaging blank cells
 

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.

"Scott W" wrote:

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