Average of multiple range with error values
Werner,
Machine 3 and 4 is being excluded because the values in C37 and C38 are not
numbers, so it works as you want.
You could use
=MITTELWERT(WENN(ISTZAHL(C35:C36);C35:C36);WENN(IS TZAHL(C39:C45);C39:C45))
which is again an array formula, but I can't see that it is neceesarry.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Werner Rohrmoser" wrote in message
...
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
|