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?