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

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

# COUNTIF

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

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

# 504Formulas

Every Formula in Google Sheets, From ABS to ZTEST, including Vlookup and, my favorite, IF()

EXPON.DIST(x, LAMBDA, cumulative)

F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)

F.DIST.RT(x, degrees_freedom1, degrees_freedom2)

FILTER(range, condition1, [condition2])

FIND(search_for, text_to_search, [starting_at])

FINDB(search_for, text_to_search, [starting_at])

F.INV(probability, degrees_freedom1, degrees_freedom2)

F.INV.RT(probability, degrees_freedom1, degrees_freedom2)

FIXED(number, [number_of_places], [suppress_separator])

FLATTEN(range1,[range2,...])

FLOOR(value, [factor])

FLOOR.MATH(number, [significance], [mode])

FLOOR.PRECISE(number, [significance])

FORECAST(x, data_y, data_x)

FREQUENCY(data, classes)

FTEST(range1, range2)

FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])

FVSCHEDULE(principal, rate_schedule)

GAMMA.DIST(x, alpha, beta, cumulative)

GAMMA.INV(probability, alpha, beta)

GAMMALN(value)

GAUSS(z)

GESTEP(value, [step])

GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

GOOGLETRANSLATE(text, [source_language], [target_language])

GROWTH(known_data_y, [known_data_x], [new_data_x], [b])

GT(value1, value2)

GTE(value1, value2)

Displaying items **145-192** of **504** in total