Functions
A clean directory of functions with examples across spreadsheets and productivity apps.
What are you trying to do?
Choose a function group by the type of task you’re working on.
Analyze Data
Counts, averages, trends, and distributions.
Clean Up Text
Counts, averages, trends, and distributions.
Do Calculations
Split, combine, extract, and format strings.
Dynamic Arrays
Return multiple values and spill results automatically.
Financial Models
Payments, rates, depreciation, and ROI.
Find & Match Values
Lookups, returns, matching, and joining lists.
Handle Errors
Lookups, returns, matching, and joining lists.
Import & Web Data
Import data from the web and external sources.
Make Decisions
IF logic, conditions, and error handling.
Work with Dates
Add months, find weekdays, calculate durations.
Function Finder
Type a function name or keyword to filter the A–Z index instantly.
Quick Function Index
Jump to a letter, then scan names and open the function you need.
Filter
ExcelGoogle Sheets
Array The range of data you want to filter and return. This can be a single column or multiple columns, but it…
Filter
Syntax
=FILTER(array, include, [if_empty])
Syntax description
Array
The range of data you want to filter and return.
This can be a single column or multiple columns, but it must be a continuous range.
Include
One or more logical tests that return TRUE or FALSE for each row in the array.
Only rows where the condition evaluates to TRUE are included in the result.
[if_empty] (optional)
The value to return if no rows meet the condition.
If omitted, the function returns an error when no matches are found.
Forecast
ExcelGoogle Sheets
x – The future value of the independent variable you want to forecast. known_ys – The known dependent values (historical results). known_xs…
Forecast
Syntax
=FORECAST(x, known_ys, known_xs)
Syntax description
- x – The future value of the independent variable you want to forecast.
- known_ys – The known dependent values (historical results).
- known_xs – The known independent values (historical inputs).
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.