AVERAGE function ignores blanks and non-numerics so the value is not skewed if
the blanks are truly blanks or are non-numerics.

Try it.

Enter numbers in A1:A10 and =AVERAGE(A1:A10) in A11

Insert 5 blank rows at A2:A6

The average returned is now =AVARAGE(A1:A16) and returns the same result.


Gord Dibben Excel MVP

On Sat, 26 Nov 2005 15:57:24 -0600, jimbob
wrote:


How do I "count" the number of cells with a value in them? I have a
spreadsheet with 277 rows, but only some of these have data. I want to
find the "AVERAGE" of the cells with data. If I use the AVERGAE
function it uses the total number of cells (277) but some of these are
blank which skews the value. Thank in advance. So glad I found this
site. :)