Skip to content

Aggregation · Easy

How do SUMIFS and COUNTIFS work with multiple conditions?

Short answer

SUMIFS adds values that meet all of several criteria; COUNTIFS counts rows that meet them. The first argument of SUMIFS is the range to sum, followed by pairs of criteria range and criterion. Criteria can use operators such as ">=" combined with cell references.

Detailed answer

=SUMIFS(Sales[revenue], Sales[region], "South", Sales[date], ">="&DATE(2026,1,1))

  • All conditions are combined with AND.
  • For OR logic, add two SUMIFS together or use SUM(SUMIFS(..., {"South","West"})).
  • Watch out for numbers stored as text — they won't match numeric criteria.