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.