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

CEILING.PRECISE(number, [significance])

CHIDIST(x, degrees_freedom)

CHIINV(probability, degrees_freedom)

CHISQ.DIST(x, degrees_freedom, cumulative)

CHISQ.DIST.RT(x, degrees_freedom)

CHISQ.INV(probability, degrees_freedom)

CHISQ.INV.RT(probability, degrees_freedom)

CHITEST(observed_range, expected_range)

CHOOSE(index, choice1, [choice2, ...])

CODE(string)

COMBIN(n, k)

COMBINA(n, k)

COMPLEX(real_part, imaginary_part, [suffix])

CONCAT(value1, value2)

CONFIDENCE.NORM(alpha, standard_deviation, pop_size)

CONFIDENCE.T(alpha, standard_deviation, size)

CONVERT(value, start_unit, end_unit)

CORREL(data_y, data_x)

COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])

COUNTUNIQUE(value1, [value2, ...])

COUPDAYBS(settlement, maturity, frequency, [day_count_convention])

COUPDAYS(settlement, maturity, frequency, [day_count_convention])

COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])

COUPNCD(settlement, maturity, frequency, [day_count_convention])

COUPNUM(settlement, maturity, frequency, [day_count_convention])

COUPPCD(settlement, maturity, frequency, [day_count_convention])

COVARIANCE.S(data_y, data_x)

CRITBINOM(num_trials, prob_success, target_prob)

Displaying items **49-96** of **504** in total