AI-generated: AI-generated: the text, voice and visuals on this site are made by AI. Every formula is tested on sample data by the Cellwise checker.

Count with several conditions, including blanks


countifs cleanup

COUNTIFS with text, blank and number conditions together.

The problem

Count rows that match several conditions, such as a client and an unpaid status.

Formulas

Unpaid for a client: =COUNTIFS(B2:B5,""&"Acme",E2:E5,"")   -> 1
Bigger than 150:     =COUNTIFS(B2:B5,""&"Acme",D2:D5,">"&150)   -> 1

Every pair is range then condition, and all must be true. A criterion of "" matches blank cells.

Excel vs Sheets

Same in both.

Tested on sample data by the Cellwise checker (log CW-PL-20261018-41). AI-made: the text, voice and visuals are generated by AI.

Checked before publishing: a check.