=AVERAGE(A2:Axxxxx) in A1

AVERAGE function ignores blank cells and/or text

What is in the "blank" cells that causes your average to be incorrect?

If you do have zeros(not shown) then in A1 place this array formula.

=AVERAGE(IF(A2:Axxxx0,A2:Axxxx))

Array formulas are entered with CTRL + SHIFT + ENTER


Gord Dibben Microsoft Excel MVP

On Sat, 27 Aug 2011 15:08:12 -0600, Howard Brazee
wrote:

How do I have a header on a column which is the average value of that
column's valid numbers? Blank cells should not be averaged in.