79% OFF online library of tutorials for mastering Google Sheets
Hey there! Register a new account to access the full suite of features, tutorials, and more..
Most Popular Formulas
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()
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.
Count the number of cells that meet a certain criteria. Learn how to use COUNTIF in Google Sheets. Also check out it's possible parter: UNIQUE()
Most Misused Formulas
Powerful vlookup and easy to use. Learn how to use VLOOKUP in Google Sheets. Also check out it's possible alternative: INDEX/MATCH.
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.
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.
Every Formula in Google Sheets, From ABS to ZTEST, including Vlookup and, my favorite, IF()
HLOOKUP(search_key, range, index, [is_sorted])
HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size)
HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size)
IF(logical_expression, value_if_true, value_if_false)
IFS(condition1, value1, [condition2, value2], …)
IMAGE(url, [mode], [height], [width])
IMPORTFEED(url, [query], [headers], [num_items])
IMPORTHTML(url, query, index)
IMPRODUCT(factor1, [factor2, ...])
IMSUM(value1, [value2, ...])
INDEX(reference, [row], [column])
Displaying items 193-240 of 504 in total