# List of 500+ Google Sheet Formulas and How to Use Them

Your ultimate destination for mastering Google Sheet formulas! Ready to transform your spreadsheets into powerful tools for analysis, reporting, and data management?

Our curated list of 500+ Google Sheet formulas provides in-depth insights and step-by-step guides on utilizing the most popular formulas like VLOOKUP, SUMIF, COUNTIF, IF, FILTER, and INDEX. Whether you're a beginner or an advanced user, Better Sheets offers resources tailored to your expertise level.

• Unlock the potential of VLOOKUP, a dynamic formula perfect for creating summaries and managing inventory.
• Discover the versatility of SUMIF, ideal for filtering data and calculating specific criteria.
• Learn the intricacies of IF, a powerful tool for conditional logic in your spreadsheets.
• Dive into advanced formulas like INDEX and FILTER, gaining expertise in data manipulation and analysis.

At Better Sheets, we not only demystify complex formulas but also offer insights into commonly misused ones. Our goal is to help you become a Google Sheets expert, so you can create powerful spreadsheets that save you time and effort. Examples and step-by-step guides are included to help you master each formula and apply it to your own spreadsheets.

# 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

# 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.

# 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.

# 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()

# 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.

# 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.

# VLOOKUP

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

# SUMIF

Don't know the syntax, or how to use SUMIF? Learn how to use SUMIF in Google Sheets. Also check out it's possible alternative: COUNTIF. Depending on what you're trying to do, SUMIF could be your solution or not.

# 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.

# 515Google Sheets Formulas

Directory of every Google Sheets formula, From ABS to ZTEST, including Vlookup and, my favorite, IF()

Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.Commo...
RSQ(data_y, data_x)
Returns the rank of a specified value in a dataset. If there is more than one entry of the same v...
RANK.EQ(value, data, [is_ascending])
Returns the rank of a specified value in a dataset. If there is more than one entry of the same v...
RANK.AVG(value, data, [is_ascending])
Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. ...
LTE(value1, value2)
Returns the requested information about the specified cell. Common questions about the CELL formu...
CELL(info_type, reference)
Returns the difference of two numbers. Equivalent to the `-` operator.Common Questions About The ...
MINUS(value1, value2)
See QUARTILECommon Questions about the QUARTILE.INC Formula:- What is the format of the QUARTILE....
QUARTILE.INC(data, quartile_number)
The PHI function returns the value of the normal distribution with mean 0 and standard deviation ...
PHI(x)
Returns a value nearest to a specified quartile of a dataset.Common questions about the QUARTILE ...
QUARTILE(data, quartile_number)
Given a set of values and corresponding probabilities, calculates the probability that a value ch...
PROB(data, probabilities, low_limit, [high_limit])
Returns the number of ways to choose some number of objects from a pool of a given size of object...
PERMUT(n, k)
Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset....
PERCENTRANK.INC(data, value, [significant_digits])
Creates and returns a custom function with a set of names and a formula_expression that uses them...
LAMBDA(name, formula_expression)
See GAMMA.INVCommon questions about the GAMMAINV formula include: - What does the GAMMAINV formul...
GAMMAINV(probability, alpha, beta)
Returns the value of the Poisson distribution function (or Poisson cumulative distribution functi...
POISSON.DIST(x, mean, [cumulative])
Also See PERCENTILECommon questions about the PERCENTILE.INC formula:1. What is the PERCENTILE.IN...
PERCENTILE.INC(data, percentile)
The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are differ...
XOR(logical_expression1, [logical_expression2, ...])
Returns a cell reference as a string.Common Questions about the ADDRESS formula:What syntax does ...
ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet])
The GAUSS function returns the probability that a random variable, drawn from a normal distributi...
GAUSS(z)
See POISSON.DISTCommon Questions About the POISSON Formula:What is the POISSON formula?This formu...
POISSON(x, mean, cumulative)
Returns the value at a given percentile of a dataset, exclusive of 0 and 1.Common questions about...
PERCENTILE.EXC(data, percentile)
Calculates r, the Pearson product-moment correlation coefficient of a dataset.Common Questions ab...
PEARSON(data_y, data_x)
Extracts an aggregated value from a pivot table that corresponds to the specified row and column ...
GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]
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])
Returns the value of the standard normal cumulative distribution function for a specified value.C...
NORMSDIST(x)
Returns a range reference shifted a specified number of rows and columns from a starting cell ref...
OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])
Returns the number of rows in a specified array or range.Common questions about the ROWS formula:...
ROWS(range)
Returns the absolute value of a number.Common questions about the ABS formula include:1. What doe...
ABS(value)
Returns the inverse hyperbolic cosine of a number.Common Questions About the ACOSH Formula: 1. Wh...
ACOSH(value)
Calculates the geometric mean of a dataset.Common questions about the GEOMEAN formula include: - ...
GEOMEAN(value1, value2)
Returns the value of the inverse normal distribution function for a specified value, mean, and st...
NORMINV(x, mean, standard_deviation)
Returns the value of the normal distribution function (or normal cumulative distribution function...
NORMDIST(x, mean, standard_deviation, cumulative)
See NORMSINVCommon Questions About the NORM.S.INV Formula1. What is the NORM.S.INV formula? 2. Ho...
NORM.S.INV(x)
See NORMSDISTCommon Questions about the NORM.S.DIST Formula:1. What is the NORM.S.DIST formula?2....
NORM.S.DIST(x)
Scans an array and produces intermediate values by application of a LAMBDA function to each value...
SCAN(initial_value, array_or_range, LAMBDA)
Calculates the sum of the differences of the squares of values in two arrays.Common Questions abo...
SUMX2MY2(array_x, array_y)
Calculates the sum of the sums of the squares of values in two arrays.Common Questions about SUMX...
SUMX2PY2(array_x, array_y)
Calculates the sum of the squares of differences of values in two arrays.Common Questions about S...
SUMXMY2(array_x, array_y)
Given partial data about a linear trend, fits an ideal linear trend using the least squares metho...
TREND(known_data_y, [known_data_x], [new_data_x], [b])
Counts numeric values selected from a database table-like array or range using a SQL-like query.C...
DCOUNT(database, field, criteria)
Returns the inverse cotangent of a value, in radians.Common questions about the ACOT Formula:1. W...
ACOT(value)
Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, in...
ACOTH(value)
Returns the inverse hyperbolic sine of a number.Common Questions about the ASINH formula: - What ...
ASINH(value)
Returns the tangent of an angle provided in radians. Common questions about the TAN formula:-What...
TAN(angle)
Counts values, including text, selected from a database table-like array or range using a SQL-lik...
DCOUNTA(database, field, criteria)
Returns the inverse tangent of a value, in radians.Common questions about the ATAN formula: What ...
ATAN(value)
Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordi...
ATAN2(x, y)
Returns the number of ways to choose some number of objects from a pool of a given size of object...
COMBIN(n, k)

Displaying items 241-288 of 515 in total

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.