Discover 500+
Google Sheet Formulas ...and how to wield'em like a sheet wizard.

Copy-able Examples • Walkthroughs • Hidden Combos

See each formula on it's own

  • IF: Automate logic in your cells.
  • VLOOKUP: Find and match data
  • SUMIF: Add up only what matters
  • FILTER: Find only the data you need

Learn powerful formula combinations

Explore

Discover a new formula randomly!
Be Brave. Give it a go 👇

Generate

Write out your problem.
AI writes you a formula.

→ Random Formula → Generate Formula

Most Used Formulas

VLOOKUP

Use VLOOKUP() when you want a specific value in a column of data. Use VLOOKUP() when you want to retrieve information from a different column based on that value. Great for creating amazing summaries, dynamic reports, or managing inventory

Learn more

SUMIF

When you need to calculate the sum of values in a range of cells that meet specific criteria, use SUMIF(). Great to use when you need to filter data. For instance, you can use it to sum all the revenue generated from a particular region, all the orders placed by a specific customer, or all the products with a certain attribute.

Learn more

COUNTIF

Use COUNTIF() when you're trying to figure out frequency. Learn how to use COUNTIF in Google Sheets. Also check out it's possible alternative: SUMIF. Depending on what you're trying to do, COUNTIF could be your solution or not.

Learn more

Most Popular Formulas

IF

Powerful and mysterious. Use IF() to make your spreadsheets gateways. Learn how to use IF in Google Sheets. Also check out it's oft-partner ISBLANK()

Learn more

FILTER

the FILTER() formula in Google Sheets allows you to filter data based on a set of criteria. Learn how to use FILTER in Google Sheets. Also check out it's possible combination alternative: INDEX/SORT.

Learn more

INDEX

A seemingly innocent and useless formula can be so powerful. INDEX pairs nicely with MATCH to replace VLOOKUP. And it's uses are almost endless. Learn more about the INDEX() formula in Google Sheets.

Learn more

Most Misused Formulas

VLOOKUP

Powerful vlookup and easy to use. Learn how to use VLOOKUP in Google Sheets. Also check out it's possible alternative: INDEX/MATCH.

Learn more

SUMIF

Depending on what you're trying to do, SUMIF could be your solution or not. Sometimes I find SUMIFS' syntax to be easier to use. Also check out an alternative: COUNTIF.

Learn more

CONCATENATE

Probably the most easily misspelled formula in all of Google Sheets. Learn how to use CONCATENATE in Google Sheets. Also check out it's possible alternative: JOIN.

Learn more

502 Google Sheets Formulas

Directory of every Google Sheets formula.

From ABS to ZTEST. ...and my favorite formula: IF()

IF()
IF()
Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. 
IF(logical_expression, value_if_true, value_if_false)
 FILTER()
FILTER()
Returns a filtered version of the source range, returning only rows or columns which meet the spe... 
FILTER(range, condition1, [condition2])
 ISBLANK()
ISBLANK()
Checks whether the referenced cell is empty. 
ISBLANK(value)
 INDEX()
INDEX()
Returns the content of a cell, specified by row and column offset. 
INDEX(reference, [row], [column])
 COUNTA()
COUNTA()
Returns a count of the number of values in a dataset. 
COUNTA(value1, [value2, ...])
 CONCATENATE()
CONCATENATE()
Appends strings to one another. 
CONCATENATE(string1, [string2, ...])
 COUNTIF()
COUNTIF()
Returns a conditional count across a range. 
COUNTIF(range, criterion)
 ARRAYFORMULA()
ARRAYFORMULA()
Enables the display of values returned from an array formula into multiple rows and/or columns an... 
ARRAYFORMULA(array_formula)
 SPLIT()
SPLIT()
Divides text around a specified character or string, and puts each fragment into a separate cell ... 
SPLIT(text, delimiter, [split_by_each], [remove_empty_text])
 JOIN()
JOIN()
Concatenates the elements of one or more one-dimensional arrays using a specified delimiter. 
JOIN(delimiter, value_or_array1, [value_or_array2, ...])
 MATCH()
MATCH()
Returns the relative position of an item in a range that matches a specified value. 
MATCH(search_key, range, [search_type])
 TRANSPOSE()
TRANSPOSE()
Transposes the rows and columns of an array or range of cells. 
TRANSPOSE(array_or_range)
 SUM()
SUM()
Returns the sum of a series of numbers and/or cells. 
SUM(value1, [value2, ...])
 VLOOKUP()
VLOOKUP()
Vertical lookup. Searches down the first column of a range for a key and returns the value of a s... 
VLOOKUP(search_key, range, index, [is_sorted])
 SUBSTITUTE()
SUBSTITUTE()
Replaces existing text with new text in a string. 
SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
 UNIQUE()
UNIQUE()
Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the... 
UNIQUE(range)
 IFERROR()
IFERROR()
Returns the first argument if it is not an error value, otherwise returns the second argument if ... 
IFERROR(value, [value_if_error])
 IMAGE()
IMAGE()
Inserts an image into a cell. 
IMAGE(url, [mode], [height], [width])
 ROUND()
ROUND()
Rounds a number to a certain number of decimal places according to standard rules. 
ROUND(value, [places])
 SORT()
SORT()
Sorts the rows of a given array or range by the values in one or more columns. 
SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])
 TODAY()
TODAY()
Returns the current date as a date value. 
TODAY()
 LEN()
LEN()
Returns the length of a string. 
LEN(text)
 IFNA()
IFNA()
Evaluates a value. If the value is an #N/A error, returns the specified value.. 
IFNA(value, value_if_na)
 IMPORTRANGE()
IMPORTRANGE()
Imports a range of cells from a specified spreadsheet. 
IMPORTRANGE(spreadsheet_url, range_string)
 CONCAT()
CONCAT()
Returns the concatenation of two values. Equivalent to the `&` operator. 
CONCAT(value1, value2)
 HYPERLINK()
HYPERLINK()
Creates a hyperlink inside a cell. 
HYPERLINK(url, [link_label])
 ROW()
ROW()
Returns the row number of a specified cell. 
ROW([cell_reference])
 LOWER()
LOWER()
Converts a specified string to lowercase. 
LOWER(text)
 SWITCH()
SWITCH()
Tests an expression against a list of cases and returns the corresponding value of the first matc... 
SWITCH(expression, case1, value1, [default or case2, value2], …)
 SPARKLINE()
SPARKLINE()
Creates a miniature chart contained within a single cell. 
SPARKLINE(data, [options])
 INDIRECT()
INDIRECT()
Returns a cell reference specified by a string. 
INDIRECT(cell_reference_as_string, [is_A1_notation])
 RANDBETWEEN()
RANDBETWEEN()
Returns a uniformly random integer between two values, inclusive. 
RANDBETWEEN(low, high)
 AND()
AND()
Returns true if all of the provided arguments are logically true, and false if any of the provide... 
AND(logical_expression1, [logical_expression2, ...])
 UPPER()
UPPER()
Converts a specified string to uppercase. 
UPPER(text)
 RAND()
RAND()
Returns a random number between 0 inclusive and 1 exclusive. 
RAND()
 MAX()
MAX()
Returns the maximum value in a numeric dataset. 
MAX(value1, [value2, ...])
 AVERAGE()
AVERAGE()
Returns the numerical average value in a dataset, ignoring text. 
AVERAGE(value1, [value2, ...])
 NOW()
NOW()
Returns the current date and time as a date value. 
NOW()
 PROPER()
PROPER()
Capitalizes each word in a specified string. 
PROPER(text_to_capitalize)
 REPT()
REPT()
Returns specified text repeated a number of times. 
REPT(text_to_repeat, number_of_repetitions)
 TEXT()
TEXT()
Converts a number into text according to a specified format. 
TEXT(number, format)
 COLUMN()
COLUMN()
Returns the column number of a specified cell, with `A=1`. 
COLUMN([cell_reference])
 SEARCH()
SEARCH()
Returns the position at which a string is first found within text. 
SEARCH(search_for, text_to_search, [starting_at])
 SUMIF()
SUMIF()
Returns a conditional sum across a range. 
SUMIF(range, criterion, [sum_range])
 FIND()
FIND()
Returns the position at which a string is first found within text. 
FIND(search_for, text_to_search, [starting_at])
 REGEXMATCH()
REGEXMATCH()
Whether a piece of text matches a regular expression. 
REGEXMATCH(text, regular_expression)
 MONTH()
MONTH()
Returns the month of the year a specific date falls in, in numeric format. 
MONTH(date)
 GOOGLEFINANCE()
GOOGLEFINANCE()
Fetches current or historical securities information from Google Finance. 
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

Displaying items 1-48 of 502 in total

Get Instant Access

Better Sheets

Stop guessing your way through Google Sheets. Pick up beginner tutorials when you're stuck on the basics. And study advanced workflows when you're ready to automate. Practical lessons, zero fluff.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons