Jacob,

Unfortunately I copied and pasted your response and the error message
appeared #VALUE!

Thanks,

John

"Jacob Skaria" wrote:

Try this

=Round(AVERAGE(IF(A4:T40,A4:T4)),1)

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

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