Need to exclude certain cells in a range

[Bob Smith]

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

 

[Bob Phillips]

=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)

 

[Don Guillett]

Have you tried it?

 

[Bob Smith]

Thanks for the reply Bob. Unfortunately, that formula did not work. I hope
you don't mind, but I sent you a 17K worksheet to see what I'm trying to do.

Regards,

Bob