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

Are you ready to transform your spreadsheets into powerful tools? Transform your analysis, reporting, and data management.


Our curated list of 500+ Google Sheet formulas provides step-by-step guides on using the most popular formulas, like: VLOOKUP, SUMIF, COUNTIF, IF, FILTER, and INDEX.


  • Unlock the potential of VLOOKUP: Perfect for managing inventory.
  • Discover the versatility of SUMIF: ideal for filtering data and summation.
  • Learn the many uses of IF: a powerful tool to build logic in to your spreadsheets.
  • Dive into advanced formulas like INDEX and FILTER: You'll need these for deep analysis.

At Better Sheets, we not only demystify complex formulas but also offer insights into commonly misused ones.


The goal is to help you become a Google Sheets expert, so you can create powerful spreadsheets that save you time and effort.

Explore a Random Sheet Formula

Discover new formulas.

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

Returns the real coefficient of a complex number.Common questions about the IMREAL formula includ...
IMREAL(complex_number)
Returns the average of a set of values selected from a database table-like array or range using a...
DAVERAGE(database, field, criteria)
Returns the result of multiplying a series of complex numbers together.Q: What are the common que...
IMPRODUCT(factor1, [factor2, ...])
Returns the tangent of the given complex number.Common questions about the IMTAN formula include:...
IMTAN(number)
Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, b...
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
Returns the standard deviation of a population sample selected from a database table-like array o...
DSTDEV(database, field, criteria)
Returns the difference between two days based on the 360 day year used in some financial interest...
DAYS360(start_date, end_date, [method])
Calculates next coupon, or interest payment, date after the settlement date.Common Questions Abou...
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Returns the first n items in a data set after performing a sort.Common Questions about the SORTN ...
SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)
Calculates the accrued interest of a security that has periodic payments.Common questions about t...
ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])
Calculates the accrued interest of a security that pays interest at maturity.The ACCRINTM formula...
ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Returns the greatest common divisor of one or more integers.Common questions about the GCD formul...
GCD(value1, value2)
Calculates the number of compounding periods required for an investment of a specified present va...
DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .
Calculates the depreciation of an asset for a specified period using the arithmetic declining bal...
DB(cost, salvage, life, period, [month])
Returns the hyperbolic secant of the given complex number. For example, a given complex number "x...
IMSECH(number)
Calculates the future value of some principal based on a specified series of potentially varying ...
FVSCHEDULE(principal, rate_schedule)
The ISPMT function calculates the interest paid during a particular period of an investment.Commo...
ISPMT(rate, period, number_of_periods, present_value)
Returns the Gamma function evaluated at the specified value.Common Questions about the GAMMA Form...
GAMMA(number)
Calculates the modified internal rate of return on an investment based on a series of periodic ca...
MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)
Returns an element from a list of choices based on index.Common questions about the CHOOSE formul...
CHOOSE(index, choice1, [choice2, ...])
Looks through a row or column for a key and returns the value of the cell in a result range locat...
LOOKUP(search_key, search_range|search_result_array, [result_range])
Returns the inverse cosine of a value, in radians.Common questions about the ACOS formula:1. What...
ACOS(value)
Calculates the interest rate of an annuity investment based on constant-amount periodic payments ...
RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])
Calculates the number of payment periods for an investment based on constant-amount periodic paym...
NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])
Returns the number of periods for an investment to reach a specific value at a given rate.Common ...
PDURATION(rate, present_value, future_value)
Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on...
PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])
Calculates the amount received at maturity for an investment in fixed-income securities purchased...
RECEIVED(settlement, maturity, investment, discount, [day_count_convention])
Calculates the price of a US Treasury Bill based on discount rate.Common Questions About the TBIL...
TBILLPRICE(settlement, maturity, discount)
Returns an array of specified dimensions with values calculated by application of a LAMBDA functi...
MAKEARRAY(rows, columns, LAMBDA)
Returns the matrix determinant of a square matrix specified as an array or range.Common questions...
MDETERM(square_matrix)
Calculates the matrix product of two matrices specified as arrays or ranges.Common questions abou...
MMULT(matrix1, matrix2)
Returns the minute component of a specific time, in numeric format.Common Questions about the MIN...
MINUTE(time)
Checks whether a provided number is between two other numbers either inclusively or exclusively.C...
ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)
Given partial data about an exponential growth curve, calculates various parameters about the bes...
LOGEST(known_data_y, [known_data_x], [b], [verbose])
Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.C...
SUMPRODUCT(array1, [array2, ...])

Displaying items 481-515 of 515 in total