Math & Statisticsintermediate
SUMIFS for monthly revenue by category
=SUMIFS($D:$D,$B:$B,$G$2,$C:$C,">="&DATE(2026,1,1),$C:$C,"<"&DATE(2026,2,1))
Excel how-to guide
How to countifs active customers in Excel
Build quick KPI tiles for dashboard summaries without creating a pivot table.
Step-by-step instructions
How to countifs active customers — 3 steps
1
Point COUNTIFS at the status column and require the value Active.
2
Add the segment column as a second condition.
3
Reference the selected segment from a summary cell like G2.
Example data
Worked example
| Customer | Status | Segment |
|---|---|---|
| Acme | Active | Enterprise |
| Nova | Active | SMB |
| Luna | Inactive | Enterprise |
Common mistakes
Errors to watch out for
Count is too low
Check for extra spaces or inconsistent labels like Active vs active in your source data.
FAQ
Frequently asked questions
Can COUNTIFS count date-based activity too?
Yes. Add another criteria range and a date condition to further narrow the result.
Describe your exact spreadsheet problem — get the formula in seconds.
Open AI Formula Generator — FreeRelated how-to guides