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