how do I average a range which also contains empty cells
 

I am attempting to average a column of numbers; however, some cells in the
column are blank. Is there any means of using the average formula that will
calculate the correct average to that will also incorporate the empty cells?

Tom
Pensacola, FL

how do I average a range which also contains empty cells
 

The AVERAGE function does not get upset by empty cells.
--
David Biddulph

Tom wrote:
I am attempting to average a column of numbers; however, some cells
in the column are blank. Is there any means of using the average
formula that will calculate the correct average to that will also
incorporate the empty cells?

Tom
Pensacola, FL

how do I average a range which also contains empty cells
 

Tom,

=SUM(A1:A10)/10

Mike

"Tom" wrote:

I am attempting to average a column of numbers; however, some cells in the
column are blank. Is there any means of using the average formula that will
calculate the correct average to that will also incorporate the empty cells?

Tom
Pensacola, FL

how do I average a range which also contains empty cells
 

To include empty cells and assign them a value of 0:

=SUM(A1:A10)/ROWS(A1:A10)

--
Biff
Microsoft Excel MVP


"Tom" wrote in message
...
I am attempting to average a column of numbers; however, some cells in the
column are blank. Is there any means of using the average formula that
will
calculate the correct average to that will also incorporate the empty
cells?

Tom
Pensacola, FL