Sheets Bootcamp

Search... Ctrl K

Google Sheets Function Reference

Quick-reference guide to Google Sheets functions. Each entry includes syntax, parameters, examples, and links to our full tutorials.

🔍 Lookup (5) ⚡ Logical (3) ➕ Math (2) 📊 Statistical (1) 📝 Text (1) 📅 Date & Time (2) 🗄 Database (1)

15 functions

7 categories

🔍

Lookup Functions

Function	Description	Syntax
IMPORTRANGE	IMPORTRANGE imports a range of cells from one Google Sheets spreadsheet into another. Syntax, examples, and access permi...	`IMPORTRANGE(spreadsheet_url, range_string)`
INDEX	INDEX returns the value of a cell in a range based on the row and column numbers you specify. Syntax, examples, and comm...	`INDEX(reference, [row], [column])`
MATCH	MATCH returns the relative position of a value within a one-dimensional range. Syntax, examples, and common errors expla...	`MATCH(search_key, range, [search_type])`
VLOOKUP	VLOOKUP searches down the first column of a range and returns a value from any column in the same row. Syntax, examples,...	`VLOOKUP(search_key, range, index, [is_sorted])`
XLOOKUP	XLOOKUP searches a range for a key and returns a value from a result range. A more flexible replacement for VLOOKUP with...	`XLOOKUP(search_key, lookup_range, result_range, [missing_value], [match_mode], [search_mode])`

⚡

Logical Functions

Function	Description	Syntax
IF	Learn how to use the IF function in Google Sheets to return different values based on whether a condition is true or fal...	`IF(logical_expression, value_if_true, value_if_false)`
IFERROR	Learn how to use the IFERROR function in Google Sheets to catch errors and return a fallback value instead of displaying...	`IFERROR(value, [value_if_error])`
IFS	Learn how to use the IFS function in Google Sheets to evaluate multiple conditions and return the value for the first on...	`IFS(condition1, value1, [condition2, value2, ...])`

➕

Math Functions

Function	Description	Syntax
SUM	SUM adds numbers together from individual values, cell references, or entire ranges. Learn the syntax, examples, and com...	`SUM(value1, [value2, ...])`
SUMIF	SUMIF adds values in a range that meet a condition you specify. Learn the syntax, see practical examples, and fix common...	`SUMIF(range, criterion, [sum_range])`

📊

Statistical Functions

Function	Description	Syntax
COUNTIF	COUNTIF counts the number of cells in a range that match a condition. Learn the syntax, see examples with wildcards, and...	`COUNTIF(range, criterion)`

📝

Text Functions

Function	Description	Syntax
CONCATENATE	CONCATENATE joins two or more text strings into one. Learn the syntax, see examples for names and addresses, and when to...	`CONCATENATE(string1, [string2, ...])`

📅

Date & Time Functions

Function	Description	Syntax
DATEDIF	DATEDIF calculates the difference between two dates in years, months, or days. Learn the syntax, unit codes, examples, a...	`DATEDIF(start_date, end_date, unit)`
TODAY	TODAY returns the current date and updates automatically on each recalculation. Learn the syntax, see examples, and unde...	`TODAY()`

🗄

Database Functions

Function	Description	Syntax
QUERY	Learn how to use the QUERY function in Google Sheets to filter, sort, and summarize data using a SQL-like query language...	`QUERY(data, query, [headers])`