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 👇

→ Random Formula

Generate

Write out your problem.
AI writes you a 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

515 Google Sheets Formulas

Directory of every Google Sheets formula.

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

NOT()
NOT()
Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE... 
NOT(logical_expression)
 MIN()
MIN()
Returns the minimum value in a numeric dataset.Common questions about the MIN formula in Google S... 
MIN(value1, [value2, ...])
 COUNT()
COUNT()
Returns a count of the number of numeric values in a dataset.What are the common questions about ... 
COUNT(value1, [value2, ...])
 MID()
MID()
Returns a segment of a string.Common questions about the MID formula in Google Sheets:What does t... 
MID(string, starting_at, extract_length)
 IMPORTXML()
IMPORTXML()
Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and... 
IMPORTXML(url, xpath_query)
 REGEXMATCH()
REGEXMATCH()
Whether a piece of text matches a regular expression.Tough times with REGEXMATCH?Generate a regex... 
REGEXMATCH(text, regular_expression)
 OR()
OR()
Returns true if any of the provided arguments are logically true, and false if all of the provide... 
OR(logical_expression1, [logical_expression2, ...])
 GOOGLEFINANCE()
GOOGLEFINANCE()
Fetches current or historical securities information from Google Finance.Common Questions About t... 
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
 YEAR()
YEAR()
Returns the year specified by a given date.Common questions about the YEAR formula:What is the sy... 
YEAR(date)
 ISURL()
ISURL()
Checks whether a value is a valid URL.Common Questions about the ISURL Formula:1. What does the I... 
ISURL(value)
 ROUNDUP()
ROUNDUP()
Rounds a number to a certain number of decimal places, always rounding up to the next valid incre... 
ROUNDUP(value, [places])
 DATE()
DATE()
Converts a provided year, month, and day into a date.Common questions about the DATE formula: -Wh... 
DATE(year, month, day)
 GOOGLETRANSLATE()
GOOGLETRANSLATE()
Translates text from one language into another.Common questions about the GOOGLETRANSLATE formula... 
GOOGLETRANSLATE(text, [source_language], [target_language])
 SEQUENCE()
SEQUENCE()
Returns an array of sequential numbers, such as 1, 2, 3, 4.Common questions about the SEQUENCE fo... 
SEQUENCE(rows, columns, start, step)
 CHAR()
CHAR()
Convert a number into a character according to the current Unicode table.The CHAR formula in Goog... 
CHAR(table_number)
 IFS()
IFS()
Evaluates multiple conditions and returns a value that corresponds to the first true condition.Co... 
IFS(condition1, value1, [condition2, value2], …)
 TRUE()
TRUE()
Returns the logical value `TRUE`.Common Questions About the TRUE Formula:1. What is the TRUE form... 
TRUE()
 COUNTBLANK()
COUNTBLANK()
Returns the number of empty cells in a given range.Common questions about the COUNTBLANK formula:... 
COUNTBLANK(range)
 QUERY()
QUERY()
Runs a Google Visualization API Query Language query across data.Common questions about the QUERY... 
QUERY(data, query, [headers])
 COUNTUNIQUEIFS()
COUNTUNIQUEIFS()
Returns the unique count of a range depending on multiple criteria.Example Usage:COUNTUNIQUEIFS(A... 
COUNTUNIQUEIFS(count_unique_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
 COUNTUNIQUE()
COUNTUNIQUE()
Counts the number of unique values in a list of specified values and ranges.Common questions abou... 
COUNTUNIQUE(value1, [value2, ...])
 EOMONTH()
EOMONTH()
Returns a date representing the last day of a month which falls a specified number of months befo... 
EOMONTH(start_date, months)
 ISTEXT()
ISTEXT()
Checks whether a value is text.Common questions about the ISTEXT formula include: - What does the... 
ISTEXT(value)
 ROUNDDOWN()
ROUNDDOWN()
Rounds a number to a certain number of decimal places, always rounding down to the next valid inc... 
ROUNDDOWN(value, [places])
 DETECTLANGUAGE()
DETECTLANGUAGE()
Identifies the language used in text within the specified range.Common questions about the DETECT... 
DETECTLANGUAGE(text_or_range)
 WEEKDAY()
WEEKDAY()
Returns a number representing the day of the week of the date provided.Common questions about the... 
WEEKDAY(date, [type])
 FV()
FV()
Calculates the future value of an annuity investment based on constant-amount periodic payments a... 
FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])
 WORKDAY()
WORKDAY()
Calculates the end date after a specified number of working days.Common Questions about the WORKD... 
WORKDAY(start_date, num_days, [holidays])
 NE()
NE()
Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `&l... 
NE(value1, value2)
 TRIM()
TRIM()
Removes leading and trailing spaces in a specified string.Common Questions about the TRIM Formula... 
TRIM(text)
 TIMEVALUE()
TIMEVALUE()
Returns the fraction of a 24-hour day the time represents.Common Questions about the TIMEVALUE Fo... 
TIMEVALUE(time_string)
 DAY()
DAY()
Returns the day of the month that a specific date falls on, in numeric format.Common Questions ab... 
DAY(date)
 ENCODEURL()
ENCODEURL()
Encodes a string of text for the purpose of using in a URL query.Common Questions About The ENCOD... 
ENCODEURL(text)
 DCOUNTA()
DCOUNTA()
Counts values, including text, selected from a database table-like array or range using a SQL-lik... 
DCOUNTA(database, field, criteria)
 HOUR()
HOUR()
Returns the hour component of a specific time, in numeric format.Common questions about the HOUR ... 
HOUR(time)
 ISEMAIL()
ISEMAIL()
Checks whether a value is a valid email address.Common questions about the ISEMAIL formula includ... 
ISEMAIL(value)
 HLOOKUP()
HLOOKUP()
Horizontal lookup. Searches across the first row of a range for a key and returns the value of a ... 
HLOOKUP(search_key, range, index, [is_sorted])
 DEC2HEX()
DEC2HEX()
Converts a decimal number to signed hexadecimal format.Common Questions about the DEC2HEX Formula... 
DEC2HEX(decimal_number, [significant_digits])
 VSTACK()
VSTACK()
This function appends ranges vertically and in sequence to return a larger array. 
VSTACK(range1; [range2, …])
 REGEXREPLACE()
REGEXREPLACE()
Replaces part of a text string with a different text string using regular expressions.Common Ques... 
REGEXREPLACE(text, regular_expression, replacement)
 COUNTIFS()
COUNTIFS()
Returns the count of a range depending on multiple criteria.Common questions about the COUNTIFS F... 
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
 VALUE()
VALUE()
Converts a string in any of the date, time or number formats that Google Sheets understands into ... 
VALUE(text)
 REGEXEXTRACT()
REGEXEXTRACT()
Extracts matching substrings according to a regular expression.Common questions about the REGEXEX... 
REGEXEXTRACT(text, regular_expression)
 LEFT()
LEFT()
Returns a substring from the beginning of a specified string.Common Questions about the LEFT() fo... 
LEFT(string, [number_of_characters])
 RIGHT()
RIGHT()
Returns a substring from the end of a specified string.Common questions about the RIGHT formula:1... 
RIGHT(string, [number_of_characters])
 ISFORMULA()
ISFORMULA()
Checks whether a formula or function is in the referenced cell.Common questions about the ISFORMU... 
ISFORMULA(cell)
 RANK()
RANK()
Returns the rank of a specified value in a dataset.Common questions about the RANK formula:What p... 
RANK(value, data, [is_ascending])
 EDATE()
EDATE()
Returns a date a specified number of months before or after another date.What are the common ques... 
EDATE(start_date, months)

Displaying items 49-96 of 515 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