Thread: Need to exclude certain cells in a range

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)

"Bob Smith" <usirsclt_No_Spamola_@earthlink.net> wrote in message
news:5qJ6g.1259$Ae1.1032@newsread1.news.pas.earthlink.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
>
>
>

Have you tried it?

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Bob Smith" <usirsclt_No_Spamola_@earthlink.net> wrote in message
news:5qJ6g.1259$Ae1.1032@newsread1.news.pas.earthlink.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
>
>
>

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

"Bob Phillips" <bob.NGs@googlemailxxx.com> wrote in message
news:u7SsOMFcGHA.3952@TK2MSFTNGP04.phx.gbl...
> =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" <usirsclt_No_Spamola_@earthlink.net> wrote in message
> news:5qJ6g.1259$Ae1.1032@newsread1.news.pas.earthlink.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
>>
>>
>>
>
>