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

CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

DATEDIF(start_date, end_date, unit)

DAVERAGE(database, field, criteria)

DAYS360(start_date, end_date, [method])

DB(cost, salvage, life, period, [month])

DCOUNT(database, field, criteria)

DCOUNTA(database, field, criteria)

DDB(cost, salvage, life, period, [factor])

DEC2BIN(decimal_number, [significant_digits])

DEC2HEX(decimal_number, [significant_digits])

DEC2OCT(decimal_number, [significant_digits])

DECIMAL(value, base)

DETECTLANGUAGE(text_or_range)

DGET(database, field, criteria)

DISC(settlement, maturity, price, redemption, [day_count_convention])

DIVIDE(dividend, divisor)

DMAX(database, field, criteria)

DMIN(database, field, criteria)

DOLLAR(number, [number_of_places])

DOLLARDE(fractional_price, unit)

DOLLARFR(decimal_price, unit)

DPRODUCT(database, field, criteria)

DSTDEV(database, field, criteria)

DSTDEVP(database, field, criteria)

DSUM(database, field, criteria)

DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .

DVAR(database, field, criteria)

DVARP(database, field, criteria)

EDATE(start_date, months)

EFFECT(nominal_rate, periods_per_year)

EOMONTH(start_date, months)

EQ(value1, value2)

ERF(lower_bound, [upper_bound])

ERROR.TYPE(reference)

Displaying items **97-144** of **504** in total