Sorry forgot to mention that this is an array fomula. Within the cell in edit
mode (F2) paste this formula and press Ctrl+Shift+Enter to apply this
formula. If successful in the Formula Bar you can notice the curly braces at
both ends "{=<formula}"
--
If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

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