Create a simple average that does NOT include blanks cells
 

Hi all,

How can I create a simple average calculation that does not include a cell
that's blank.

For example, I do a simple average all cells A2:A10. BUT, if one of those
is blank, it treats is a 'zero' and skews the average calculation. I don't
want it to include the blank cells as part of the formula. Only when a
number is entered into one of the cells should it be included in the Average
function.

Can this be done? Thanks so much!

Create a simple average that does NOT include blanks cells
 

how are you doing your average?

Using 2003 the average() function ignores blank cells?
could you actually have a zero in cell but have zeros so they don't display?

"Access Joe" wrote:

Hi all,

How can I create a simple average calculation that does not include a cell
that's blank.

For example, I do a simple average all cells A2:A10. BUT, if one of those
is blank, it treats is a 'zero' and skews the average calculation. I don't
want it to include the blank cells as part of the formula. Only when a
number is entered into one of the cells should it be included in the Average
function.

Can this be done? Thanks so much!

Create a simple average that does NOT include blanks cells
 

Average does *not* include blank cells in it's calculation.

Even zero length strings (nulls [ "" ]) are bypassed.

Are you sure those cells are blank?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Access Joe" wrote in message
...
Hi all,

How can I create a simple average calculation that does not include a cell
that's blank.

For example, I do a simple average all cells A2:A10. BUT, if one of those
is blank, it treats is a 'zero' and skews the average calculation. I
don't
want it to include the blank cells as part of the formula. Only when a
number is entered into one of the cells should it be included in the
Average
function.

Can this be done? Thanks so much!

Create a simple average that does NOT include blanks cells
 

Look at that. One of those things Microsoft never really mentioned in the
upgrade, huh.

Thanks BJ.

"bj" wrote:

how are you doing your average?

Using 2003 the average() function ignores blank cells?
could you actually have a zero in cell but have zeros so they don't display?

"Access Joe" wrote:

Hi all,

How can I create a simple average calculation that does not include a cell
that's blank.

For example, I do a simple average all cells A2:A10. BUT, if one of those
is blank, it treats is a 'zero' and skews the average calculation. I don't
want it to include the blank cells as part of the formula. Only when a
number is entered into one of the cells should it be included in the Average
function.

Can this be done? Thanks so much!

Create a simple average that does NOT include blanks cells
 

AVERAGE has ignored blanks for many versions before 2003.


Gord Dibben MS Excel MVP

On Wed, 17 Oct 2007 12:55:03 -0700, Access Joe
wrote:

Look at that. One of those things Microsoft never really mentioned in the
upgrade, huh.

Thanks BJ.

"bj" wrote:

how are you doing your average?

Using 2003 the average() function ignores blank cells?
could you actually have a zero in cell but have zeros so they don't display?

"Access Joe" wrote:

Hi all,

How can I create a simple average calculation that does not include a cell
that's blank.

For example, I do a simple average all cells A2:A10. BUT, if one of those
is blank, it treats is a 'zero' and skews the average calculation. I don't
want it to include the blank cells as part of the formula. Only when a
number is entered into one of the cells should it be included in the Average
function.

Can this be done? Thanks so much!