Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y

Question

I want to show the Time Approved average from the following collection of data. However, I only want to show the Time Approved average when the Approval Type and Approver are both Yellow Type.

If I wanted to, I could use AverageIf() to obtain Cathy's average time authorized, but what if the approval type was Yellow Type? How would I go about obtaining Cathy's average then?

Answer 1

Use AVERAGEIFS ...

=AVERAGEIFS(C2:C13,A2:A13,"Yellow Type",B2:B13,"Cathy")