Hi Excel Pros,
Table:
Name Price New/Old
A 10 Y
A 20 N
B 35 Y
B 45 Y
C 50 N
C 60 Y
<tbody>
</tbody>This is working perfectly
However, I don't know how to find: The average price when name = A or B and New/Old = Y.
The correct answer is supposed to be: (10+35+45)/3 = 30
Thanks in advance!
Table:
Name Price New/Old
A 10 Y
A 20 N
B 35 Y
B 45 Y
C 50 N
C 60 Y
If I want to find: The average price when name = A and New/Old = Y: IFERROR(AVERAGEIFS($B$2:$B$7, $A$2:$A$7, "A", $C$2:$C$7, "Y"),"") = 10 |
<tbody>
</tbody>
However, I don't know how to find: The average price when name = A or B and New/Old = Y.
The correct answer is supposed to be: (10+35+45)/3 = 30
Thanks in advance!