COUNTIFS

Counts rows that meet multiple criteria across one or more columns. Works on same-sheet column ranges and cross-sheet references.

Syntax

smartsheet-mastery

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

Example

smartsheet-mastery

// Count at-risk high-priority tasks
=COUNTIFS([Status]:[Status], "At Risk", [Priority]:[Priority], "High")

// Count with cross-sheet reference
=COUNTIFS({Portfolio Status}, "At Risk", {Portfolio Owner}, "Alice")