Try this array* formula:

=AVERAGE(IF(NOT(ISERROR(A1:A12)),A1:A12))

* An array formula has to be committed using CTRL-SHIFT-ENTER (CSE)
rather than the usual ENTER. If you do this correctly then Excel will
wrap curly braces { } around the formula when viewed in the formula
bar - do not type these yourself. Use CSE again whenever you edit the
formula.

Obviously, adjust the ranges to suit your situation.

Hope this helps.

Pete

On Jun 19, 2:41*pm, Keller2 wrote:
I have a WORKBOOK with series of monthly worksheets with a TOTALS worksheet
that pulls the values from the appropriate monthly worksheets which are input
as each months numbers are added. *The TOTALS worksheet needs to average only
the monthly totals to date. The cells in the TOTALS worksheet display #DIV/0!
until the corresponding worksheet is updated each month.

How to I get an average of just the cells that contain values and not count
the cells that display #DIV/0!, and do not have values yet?