can you elaborate al little? which cell (s) does this go in?

"Bob Phillips" wrote:

I think you want this array formula

=AVERAGE(IF(ISNUMBER(I1:I5),I1:I5))

As an arary formula, commit with Ctrl-Shift-Enter, not just Enter.

--
__________________________________
HTH

Bob

"nomad" wrote in message
...
I need to get a sum function to recognise an 'x' or 'NA' as a number as not
to mess up an overall percentage function later on in the worksheet.
This is for an inspection & cells would usually have a 1 - 5 value placed
in
them but sometimes the field is not applicable.
Is it possible??
Can anyone help??