Thread: Average of multiple range with error values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Werner Rohrmoser Werner Rohrmoser is offline
external usenet poster
  
Posts: 88
Default Average of multiple range with error values
Bob,

my problem is that Machine 3 and 4 is not included, so I do not have
one range.
What I'm looking for is a formula which can handle multiple
independant ranges.

My formula should be:"{=MITTELWERT(WENN(ISTZAHL((C35:C36;C39:C45));
(C35:C36;C39:C45)))}
but this doesn't work.

Werner
Reply With QuoteReply With Quote