Use SUMIFS, COUNTIFS, and AVERAGEIFS for multiple criteria
Syntax: SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)
Step 1: Identify the range you want to sum, count or average (sum_range, count_range, or average_range).
Step 2: Define criteria_range and criteria for each condition.
Step 3: Enter the formula in a cell and press Enter.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com