Need to calculate average if values fall into EITHER range.

[daxplicitazn]

I have two ranges that can be met.

If value falls into EITHER one of those ranges I want to to calculate the average, if it doesnt fit into either one then i want to display not in range.

I also want to determine either A or B based on what range it falls under.

Pretty much i want to label something A if it falls into range 1 or label it b if it falls into range 2, and display "no good" if it doesnt fall into either range.

I dont know if im conveying my issue properly. Any help would be appreciated.

[daffodil11]

The max of B is within the range of A.

[shg]

Please Login or Register  to view this content.

The formula in C2 and copied down is

=CHOOSE((MEDIAN(B2, $F$2:$G$2)=B2) + 2 * (MEDIAN(B2, $F$3:$G$3) = B2) + 1, "Neither", "A", "B", "Both")

In B11,

=AVERAGEIF($C$2:$C$9, "<>Neither", $B$2:$B$9)