Use COUNTIFS for Multiple Conditions

COUNTIFS counts rows that meet multiple conditions at the same time.

• Select the range to count.
• Add each criteria range and criterion pair.
• Use absolute references when building reusable reports.