Conditional Sums & Counts Functions
SUMIF, COUNTIF and friends: totals that only include matching rows. Each function below has a side-by-side syntax table for Excel, Google Sheets, Airtable and Notion, a live tester, and one-click copy buttons.
| Function | What it does | Excel | Google Sheets | Airtable | Notion |
|---|---|---|---|---|---|
| SUMIF | Add up the values in rows that meet one condition | ✔ | ✔ | ✘ | ≈ |
| SUMIFS | Add up the values in rows that meet several conditions | ✔ | ✔ | ✘ | ≈ |
| COUNTIF | Count the cells that meet one condition | ✔ | ✔ | ✘ | ≈ |
| COUNTIFS | Count the rows that meet several conditions | ✔ | ✔ | ✘ | ≈ |
| AVERAGEIF | Average the values in rows that meet a condition | ✔ | ✔ | ✘ | ≈ |
✔ built-in function ≈ works with a workaround formula ✘ not available