Math & Statisticsintermediate
COUNTIFS for active customers by segment
=COUNTIFS($B:$B,"Active",$C:$C,$G$2)
Worked examples (1)
These formulas work in Google Sheets with identical syntax.
Also in Excel
See the full COUNTIFS reference for Excel — including all worked examples, common errors, and FAQ.
COUNTIFS Excel reference →