515 Google Sheets Formulas
Directory of every Google Sheets formula.
From ABS to ZTEST. ...and my favorite formula: IF()
Discover 500+
Google Sheet Formulas
...and how to wield'em like a sheet wizard.
Copy-able Examples • Walkthroughs • Hidden Combos
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
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.
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.
CORREL()
CORREL(data_y, data_x)
IMPRODUCT()
IMPRODUCT(factor1, [factor2, ...])
PV()
PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])
BITAND()
BITAND(value1, value2)
DAVERAGE()
DAVERAGE(database, field, criteria)
IMPORTHTML()
IMPORTHTML(url, query, index)
YIELDDISC()
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
IMREAL()
IMREAL(complex_number)
EFFECT()
EFFECT(nominal_rate, periods_per_year)
FREQUENCY()
FREQUENCY(data, classes)
BYCOL()
BYCOL(array_or_range, LAMBDA)
HEX2BIN()
HEX2BIN(signed_hexadecimal_number, [significant_digits])
GESTEP()
GESTEP(value, [step])
IMLOG10()
IMLOG10(value)
BIN2OCT()
BIN2OCT(signed_binary_number, [significant_digits])
PERMUTATIONA()
PERMUTATIONA(number, number_chosen)
FORECAST.LINEAR()
FORECAST.LINEAR(x, data_y, data_x)
DOLLARFR()
DOLLARFR(decimal_price, unit)
HEX2OCT()
HEX2OCT(signed_hexadecimal_number, significant_digits)
SINH()
SINH(value)
MINVERSE()
MINVERSE(square_matrix)
PRICEMAT()
PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])
SKEW.P()
SKEW.P(value1, value2)
PRICEDISC()
PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])
NPV()
NPV(discount, cashflow1, [cashflow2, ...])
DOLLARDE()
DOLLARDE(fractional_price, unit)
STANDARDIZE()
STANDARDIZE(value, mean, standard_deviation)
STDEVPA()
STDEVPA(value1, value2)
PPMT()
PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
ROMAN()
ROMAN(number, [rule_relaxation])
T.TEST()
T.TEST(range1, range2, tails, type)
PERCENTRANK.EXC()
PERCENTRANK.EXC(data, value, [significant_digits])
VAR()
VAR(value1, [value2, ...])
PERCENTRANK()
PERCENTRANK(data, value, [significant_digits])
QUARTILE.EXC()
QUARTILE.EXC(data, quartile_number)
TTEST()
TTEST(range1, range2, tails, type)
PMT()
PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])
T.DIST.RT()
T.DIST.RT(x, degrees_freedom)
NOMINAL()
NOMINAL(effective_rate, periods_per_year)
MODE.SNGL()
MODE.SNGL(value1, [value2, ...])
SUBTOTAL()
SUBTOTAL(function_code, range1, [range2, ...])
UNICHAR()
UNICHAR(number)
NORM.INV()
NORM.INV(x, mean, standard_deviation)
TEXTJOIN()
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
CONFIDENCE()
CONFIDENCE(alpha, standard_deviation, pop_size)
IMPORTDATA()
IMPORTDATA(url)
PERCENTILE()
PERCENTILE(data, percentile)
NORMSINV()
NORMSINV(x)
Displaying items 145-192 of 515 in total