Finding Average value based on multiple criteria (multiple values)

[bootstrap]

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
[TABLE="width: 264"]
<tbody>[TR]
[TD]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

[/TD]
[/TR]
</tbody>[/TABLE]
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!

 

[VBA Geek]

try

=SUM(SUMIFS(B2:B7,C2:C7,"Y",A2:A7,{"A","B"}))/SUM(COUNTIFS(C2:C7,"Y",A2:A7,{"A","B"}))

 

[bootstrap]

try

=SUM(SUMIFS(B2:B7,C2:C7,"Y",A2:A7,{"A","B"}))/SUM(COUNTIFS(C2:C7,"Y",A2:A7,{"A","B"}))

Thank you, but I got a more direct approach.

 

[bootstrap]

Thanks everyone for reading this post! I have the solution already. Please do not waste your time on this anymore!