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.

Explore a New Sheet Formula

Discover new formulas you may never have heard of.

Generate New Sheet Formulas

Create sheet formulas based on simply stating your problem.

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

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.

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

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.

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.

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

See HYPGEOMDISTCommon questions about the HYPGEOM.DIST formula: - What does the HYPGEOM.DIST form...
HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)
Returns a single value from a database table-like array or range using a SQL-like query.Common qu...
DGET(database, field, criteria)
Returns the number of ways to choose some number of objects from a pool of a given size of object...
COMBINA(n, k)
Returns the cosine of an angle provided in radians.Common questions about the COS formula include...
COS(angle)
Calculates the probability of drawing a certain number of successes in a certain number of tries ...
HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)
Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakednes...
KURT(value1, value2)
Returns the maximum value selected from a database table-like array or range using a SQL-like que...
DMAX(database, field, criteria)
Returns the minimum value selected from a database table-like array or range using a SQL-like que...
DMIN(database, field, criteria)
Returns the product of values selected from a database table-like array or range using a SQL-like...
DPRODUCT(database, field, criteria)
Imports a RSS or ATOM feed.What are the common questions about the IMPORTFEED formula?How do I us...
IMPORTFEED(url, [query], [headers], [num_items])
Returns the sum of values selected from a database table-like array or range using a SQL-like que...
DSUM(database, field, criteria)
Returns the nth largest element from a data set, where n is user-defined.Common Questions about t...
LARGE(data, n)
Returns the variance of a population sample selected from a database table-like array or range us...
DVAR(database, field, criteria)
Returns the variance of an entire population selected from a database table-like array or range u...
DVARP(database, field, criteria)
Returns the hyperbolic cosine of any real number.Common questions about the COSH formula include:...
COSH(value)
Cotangent of an angle provided in radians.Common questions about the COT formula include: - What ...
COT(angle)
Returns the hyperbolic cotangent of any real number. Common questions about the COTH formula incl...
COTH(value)
Converts a provided date string in a known format to a date value.Common Questions About the DATE...
DATEVALUE(date_string)
Converts a signed hexadecimal number to decimal format.Common questions about the HEX2DEC formula...
HEX2DEC(signed_hexadecimal_number)
Returns absolute value of a complex number.Common questions about the IMABS formula include:• Wha...
IMABS(number)
Returns the imaginary coefficient of a complex number.Common questions about the IMAGINARY formul...
IMAGINARY(complex_number)
Returns the day of the month that a specific date falls on, in numeric format.Common Questions ab...
DAY(date)
The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given com...
IMARGUMENT(number)
Returns the cotangent of the given complex number. For example, a given complex number "x+yi" ret...
IMCOT(number)
Returns the cosecant of an angle provided in radians.Common questions about the CSC formula:1. Wh...
CSC(angle)
The CSCH function returns the hyperbolic cosecant of any real number.Common questions about the C...
CSCH(value)
Returns the value of the inverse log-normal cumulative distribution with given mean and standard ...
LOGINV(x, mean, standard_deviation)
Returns the number of the ISO week of the year where the provided date falls.Common questions abo...
ISOWEEKNUM(date)
Returns the number of net working days between two provided days.Common Questions About the NETWO...
NETWORKDAYS(start_date, end_date, [holidays])
Returns the number of net working days between two provided days excluding specified weekend days...
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
The DECIMAL function converts the text representation of a number in another base, to base 10 (de...
DECIMAL(value, base)
Converts an angle value in radians to degrees.Common Questions about the DEGREES formula:1. What ...
DEGREES(angle)
Converts a provided hour, minute, and second into a time.Common questions about the TIME formula:...
TIME(hour, minute, second)
Returns the fraction of a 24-hour day the time represents.Common Questions about the TIMEVALUE Fo...
TIMEVALUE(time_string)
Returns the complementary Gauss error function of a value.Common Questions about the ERFC Formula...
ERFC(z)
Returns the hyperbolic cotangent of the given complex number. For example, a given complex number...
IMCOTH(number)
Returns a number representing the week of the year where the provided date falls.Common questions...
WEEKNUM(date, [type])
Calculates the date after a specified number of workdays excluding specified weekend days and hol...
WORKDAY.INTL(start_date, num_days, [weekend], [holidays])
Returns the number of years, including fractional years, between two dates using a specified day ...
YEARFRAC(start_date, end_date, [day_count_convention])
Converts a signed binary number to decimal format.Common questions about the BIN2DEC formula:1. W...
BIN2DEC(signed_binary_number)
Rounds a number up to the nearest even integer.Common questions about the EVEN Formula include:Wh...
EVEN(value)
Converts a signed binary number to signed hexadecimal format.Common questions about the BIN2HEX f...
BIN2HEX(signed_binary_number, [significant_digits])
Returns the hyperbolic cosecant of the given complex number. For example, a given complex number ...
IMCSCH(number)
Returns one complex number divided by another.Common questions about the IMDIV formula include: W...
IMDIV(dividend, divisor)
Returns Euler's number, e (~2.718) raised to a complex power.Common Questions about the IMEXP For...
IMEXP(exponent)
Returns the logarithm of a complex number for a specified base.Common Questions About the IMLOG F...
IMLOG(value, base)
Shifts the bits of the input a certain number of places to the left.Common questions about the BI...
BITLSHIFT(value, shift_amount)
Returns the logarithm of a complex number with base 2.Common questions about the IMLOG2 formula i...
IMLOG2(value)

Displaying items 289-336 of 515 in total