non-contigous range ref

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello Group!

How do you reference multiple non-contigous ranges in an
IF function. I tried nesting an IF for each range but that
didn't work. I want to average the values in these ranges.
There may be zero values but I want them excluded. I do
have a solution using SUM/COUNTIF but I would like to know
how to use the AVERAGE(IF) method.

AVERAGE IF A1:A10 >0, B11:B20 >0, C21:C30 >0

I also tried AVERAGE(IF(AND))

Thanks for your help!
Bob P.
 
Leo - Thank you! I was pretty close in my attempt. I put
all the closing ')' at the end of the formula.

Bob P.
 
Back
Top