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