81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

Hey there! Register a new account to access the full suite of features, tutorials, and more..

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

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.

515Formulas

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

Returns a number raised to a power.
POW(base, exponent)
Returns a number with the sign reversed.
UMINUS(value)
Calculates the annual yield of a security paying interest at maturity, based on price.
YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
Checks whether a value is an error other than `#N/A`.
ISERR(value)
Checks whether a value is an error.Common questions about the ISERROR formula in Google Sheets:Wh...
ISERROR(value)
Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.
CHISQ.DIST.RT(x, degrees_freedom)
Calculates the inverse of the left-tailed chi-squared distribution.
CHISQ.INV(probability, degrees_freedom)
Calculates the inverse of the right-tailed chi-squared distribution.
CHISQ.INV.RT(probability, degrees_freedom)
See CHITEST
CHISQ.TEST(observed_range, expected_range)
See CONFIDENCE.NORM
CONFIDENCE(alpha, standard_deviation, pop_size)
Calculates the width of half the confidence interval for a Student’s t-distribution..
CONFIDENCE.T(alpha, standard_deviation, size)
Calculates r, the Pearson product-moment correlation coefficient of a dataset.
CORREL(data_y, data_x)
Calculates the covariance of a dataset.
COVAR(data_y, data_x)
Returns the value of the inverse log-normal cumulative distribution with given mean and standard ...
LOGINV(x, mean, standard_deviation)
See LOGNORMDIST
LOGNORM.DIST(x, mean, standard_deviation)
See LOGINV
LOGNORM.INV(x, mean, standard_deviation)
See COVAR
COVARIANCE.P(data_y, data_x)
Calculates the geometric mean of a dataset.
GEOMEAN(value1, value2)
Returns the value of the log-normal cumulative distribution with given mean and standard deviatio...
LOGNORMDIST(x, mean, standard_deviation)
Returns the maximum numeric value in a dataset.
MAXA(value1, value2)
See NORMSINV
NORM.S.INV(x)
Calculates the covariance of a dataset, where the dataset is a sample of the total population..
COVARIANCE.S(data_y, data_x)
Calculates the smallest value for which the cumulative binomial distribution is greater than or e...
CRITBINOM(num_trials, prob_success, target_prob)
Calculates the sum of squares of deviations based on a sample.
DEVSQ(value1, value2)
Returns the value of the exponential distribution function with a specified LAMBDA at a specified...
EXPON.DIST(x, LAMBDA, cumulative)
Calculates the payment on the principal of an investment based on constant-amount periodic paymen...
PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Checks whether a value is `TRUE` or `FALSE`.
ISLOGICAL(value)
Given partial data about an exponential growth curve, calculates various parameters about the bes...
LOGEST(known_data_y, [known_data_x], [b], [verbose])
Returns the matrix determinant of a square matrix specified as an array or range.
MDETERM(square_matrix)
Calculates the matrix product of two matrices specified as arrays or ranges.
MMULT(matrix1, matrix2)
Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.C...
SUMPRODUCT(array1, [array2, ...])
Calculates the sum of the differences of the squares of values in two arrays.
SUMX2MY2(array_x, array_y)
Calculates the sum of the sums of the squares of values in two arrays.
SUMX2PY2(array_x, array_y)
Calculates the number of days from the first coupon, or interest payment, until settlement.
COUPDAYBS(settlement, maturity, frequency, [day_count_convention])
Checks whether a value is the error `#N/A`.
ISNA(value)
Checks whether a value is non-textual.
ISNONTEXT(value)
Checks whether a value is a number.
ISNUMBER(value)
Checks whether a value is a valid cell reference.
ISREF(value)
Returns the argument provided as a number.
N(value)
Returns the "value not available" error, `#N/A`.Common questions about the NA formula in Google S...
NA()
Returns a number associated with the type of data passed into the function.
TYPE(value)
Returns the absolute value of a number.
ABS(value)
Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.
CHISQ.DIST(x, degrees_freedom, cumulative)
Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordi...
ATAN2(x, y)
Computes the square root of a complex number.
IMSQRT(complex_number)
See EXPON.DIST
EXPONDIST(x, LAMBDA, cumulative)
The GAUSS function returns the probability that a random variable, drawn from a normal distributi...
GAUSS(z)
Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.
PERCENTRANK.INC(data, value, [significant_digits])

Displaying items 241-288 of 515 in total