=AVERAGE(IF(ISNUMBER(A4:A53),A4:A53))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Bob Smith" wrote in message
ink.net...
This should be a simple fix, but I'm not having any luck right now
figuring
it out.

Need some help to exclude cells within a range of cells. Am doing an
average
of 50 cells, =AVERAGE(A4:A53). Some of these cells include an asterisk and
should not be included in the final average.

TIA,

Bob