I am not understanding, what do you need beyond the formula you already
have. It excludes the non-numbers already.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Werner Rohrmoser" wrote in message
...
Hi,

I'd ,like to calculate the average of Machine 1 through 2 and Machine
5 through 11.
So the range is not in one piece.
Further error values have to be excluded.
For a regular range I use "{=AVERAGE(IF(ISNUMBER(C35:C45);C35:C45))}
for example.

Machine 1 4.546
Machine 2 3.923
Machine 3 - New #NV
Machine 4 - New #NV
Machine 5 10.567
Machine 6 6.861
Machine 7 #NV
Machine 8 9.096
Machine 9 9.347
Machine 10 3.198
Machine 11 #NV

TIA
Werner

Excel 2002 SP3