Create a simple average that does NOT include blanks cells

A

Access Joe

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!
 
B

bj

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?
 
R

RagDyer

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

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

Are you sure those cells are blank?
 
A

Access Joe

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

Thanks BJ.
 
G

Gord Dibben

AVERAGE has ignored blanks for many versions before 2003.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average formula where blank cells are counted as zeros 4
average in non-continuous set, excluding blanks 6
How do I average cells that contain #DIV/01? 2
Ignoring Blank cells 9
averaging from different sheets and folders 1
Average non-consecutive cells excluding zero 8
Changing the range for averages with out changing the formula. 0
When I link blank cell in one sheet registers as 0 for averaging 3

Top