View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Average of multiple range with error values

Okay, at least I went beyond my prejudices to give you a solution <vbg

--
HTH

Bob

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

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

that's exactly what I need, excellent!

It's necessary becaues I exclude Machine 3 and 4 because they are
other types of machines
and in later years (it's a dataseries, which starts in the year 1999)
they have numbers.
So I have to exclude them also when they have numbers.

Best Regards
Werner