Previous Lecture Complete and continue  

  Multiple Criteria Conditional Aggregation: AND Testing

Get more practice using the averageifs function to aggregate data on multiple conditions when all criteria need to be true ("and testing"). We'll see how the multiple criteria conditional aggregation functions can be used on both vertical and horizontal data sets.