Average help???

[John]

Is there anyway I can include the value of the cell with a * but not perform
the average for that sepcific cell:

for example

55,67,89*,22,37

the totals would be 270 but the average would be /4 and not /5 because of
the *

Thanks for any help

John

 

[Dave Peterson]

The OP replied in a different thread that he got it working.

 

[John]

Unfortunately this is a slightly different problem and I still cannot get it
to work.

 

[Dave Peterson]

If you enter
89*
in a cell, then excel will treat it as text.

And it won't be included in the average (or sum or count of cells with numbers).

So are you typing that asterisk or is that the result of formatting? Does it
represent a negative number?