Function reference

COUNTIFS in Excel & Google Sheets

COUNTIFS is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.

1 intermediateBuild a custom COUNTIFS formula →

When to use COUNTIFS

Build quick KPI tiles for dashboard summaries without creating a pivot table.

Worked examples (1)

Math & Statisticsintermediate

COUNTIFS for active customers by segment

=COUNTIFS($B:$B,"Active",$C:$C,$G$2)

Open formula COUNTIFS reference

Common errors with COUNTIFS

Count is too low

Check for extra spaces or inconsistent labels like Active vs active in your source data.

Frequently asked questions

Can COUNTIFS count date-based activity too?

Yes. Add another criteria range and a date condition to further narrow the result.

Need a custom variation?

Describe your specific COUNTIFS problem and get a formula written for your exact data.

Open generator with COUNTIFS