Do Calculations
Split, combine, extract, and format strings.
Quick Function Index
Jump to a letter, or search to filter within this category.
SUM
ExcelGoogle Sheets
number1 – The first number, cell, or range to add. [number2] – Optional additional numbers, cells, or ranges.
SUM
Syntax
=SUM(number1, [number2], ...)
Syntax description
- number1 – The first number, cell, or range to add.
- [number2] – Optional additional numbers, cells, or ranges.
SUMIF
ExcelGoogle Sheets
Syntax Description range: The cells to test against your condition (text, numbers, dates, or logical values). criteria: The condition that decides which…
SUMIF
Syntax
=SUMIF(range, criteria, [sum_range])
Syntax description
Syntax Description
-
range: The cells to test against your condition (text, numbers, dates, or logical values).
-
criteria: The condition that decides which rows to include (for example: “East”, “>=100”, “>=”&DATE(2026,2,1)).
-
[sum_range] (optional): The cells to add. If omitted, SUMIF sums the cells in range when they meet the criteria.
Popular Functions
Hand-picked function guides that work in both Excel and Google Sheets.