In a row I have values in cells from for example A4:T4 but on the end of some
of the value I have a * and I want the average to ignore the velues with a *

Example

55,67,89*,100,10*

Thanks

"Bernie Deitrick" wrote:

John,

Any displayed values that contain a * should be text, so they should be ignored.

Any cell that contains a formuls like =A1*4 will not be ignored, since they will return a value.

So, what do you mean, exactly?

HTH,
Bernie
MS Excel MVP


"John" wrote in message
...
I am using the following formula in Excel 2003

=ROUND(AVERAGE(A4:T4),1)

and I need to ignore any values that contain a * can any please help??

Thanks in advance

John