Mastering COUNTIFS in Excel: Count Data with Multiple Conditions

Mastering COUNTIFS in Excel: Count Data with Multiple Conditions

COUNTIFS() is a powerful Excel function used to count the number of times all given conditions are met. It is perfect for analyzing large datasets and filtering with precision.

📘 Syntax:

=COUNTIFS(range1, criteria1, [range2, criteria2], ...)

✅ Example – Count Female Students Who Passed:

=COUNTIFS(B2:B100, ">=40", C2:C100, "F")

This formula counts how many female students scored 40 or more.

🎯 Use Cases:

• Track how many sales were made by a specific team member in a certain region
• Analyze students who passed and belong to a specific class or batch
• Count products above a price threshold in a specific category

🚀 Pro Tip:

COUNTIFS can handle up to 127 conditions! Always make sure the ranges are of equal length to avoid errors.

🔁 Related Formula:

Use SUMIFS to add values based on multiple conditions.

Make your data smarter with ScriptDataInsights – Excel made practical!