Averaging blank cells

S

Scott W

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
 
B

bpeltzer

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.
 
Top