software

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

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

quot;Bob Smithquot; gt; wrote in message ink.net...
gt; This should be a simple fix, but I'm not having any luck right now
figuring
gt; it out.
gt;
gt; Need some help to exclude cells within a range of cells. Am doing an
average
gt; of 50 cells, =AVERAGE(A4:A53). Some of these cells include an asterisk and
gt; should not be included in the final average.
gt;
gt; TIA,
gt;
gt; Bob
gt;
gt;
gt;
Have you tried it?

--
Don Guillett
SalesAid Software

quot;Bob Smithquot; gt; wrote in message ink.net...
gt; This should be a simple fix, but I'm not having any luck right now
gt; figuring it out.
gt;
gt; Need some help to exclude cells within a range of cells. Am doing an
gt; average of 50 cells, =AVERAGE(A4:A53). Some of these cells include an
gt; asterisk and should not be included in the final average.
gt;
gt; TIA,
gt;
gt; Bob
gt;
gt;
gt;
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

quot;Bob Phillipsquot; gt; wrote in message
...
gt; =AVERAGE(IF(ISNUMBER(A4:A53),A4:A53))
gt;
gt; which is an array formula, it should be committed with Ctrl-Shift-Enter,
gt; not
gt; just Enter.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;Bob Smithquot; gt; wrote in message
gt; ink.net...
gt;gt; This should be a simple fix, but I'm not having any luck right now
gt; figuring
gt;gt; it out.
gt;gt;
gt;gt; Need some help to exclude cells within a range of cells. Am doing an
gt; average
gt;gt; of 50 cells, =AVERAGE(A4:A53). Some of these cells include an asterisk
gt;gt; and
gt;gt; should not be included in the final average.
gt;gt;
gt;gt; TIA,
gt;gt;
gt;gt; Bob
gt;gt;
gt;gt;
gt;gt;
gt;
gt;