Spreadsheet formulas explained, side by side

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.

FunctionWhat it doesExcelGoogle SheetsAirtableNotion
SUMIFAdd up the values in rows that meet one condition✔✔✘≈
SUMIFSAdd up the values in rows that meet several conditions✔✔✘≈
COUNTIFCount the cells that meet one condition✔✔✘≈
COUNTIFSCount the rows that meet several conditions✔✔✘≈
AVERAGEIFAverage the values in rows that meet a condition✔✔✘≈

✔ built-in function   ≈ works with a workaround formula   ✘ not available