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

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

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

Directory of every Google Sheets formula, From ABS to ZTEST, including Vlookup and, my favorite, IF()

Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. ...
`GT(value1, value2)`
Returns the result of multiplying a series of numbers together.Common Questions About the PRODUCT...
`PRODUCT(factor1, [factor2, ...])`
Returns one number divided by another.Common questions about the QUOTIENT formula: -What is the s...
`QUOTIENT(dividend, divisor)`
`RADIANS(angle)`
Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwis...
`GTE(value1, value2)`
Returns the positive square root of the product of Pi and the given positive number.Common Questi...
`SQRTPI(value)`
The SEC function returns the secant of an angle, measured in radians.Common questions about the S...
`SEC(angle)`
The SECH function returns the hyperbolic secant of an angle.Common questions about the SECH formu...
`SECH(value)`
Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)...
`SERIESSUM(x, n, m, a)`
Returns the sum of two numbers. Equivalent to the `+` operator.Common questions about the ADD For...
`ADD(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.Common Questions about the MAXA Formula:- What is ...
`MAXA(value1, value2)`
Returns the maximum value in a range of cells, filtered by a set of criteria.Common Questions abo...
`MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)`
Returns a number raised to a power.Common questions about the POW Formula include:1. What is the ...
`POW(base, exponent)`
Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.Common ques...
`UNARY_PERCENT(percentage)`
Returns a specified number, unchanged.Common Questions about the UPLUS Formula:1. What is the UPL...
`UPLUS(value)`
Converts a provided number to a date.Common Questions About the TO_DATE Formula:What does the TO_...
`TO_DATE(value)`
Converts a provided number to a percentage.Common questions about the TO_PERCENT formula include:...
`TO_PERCENT(value)`
Converts a provided date/time, percentage, currency or other formatted numeric value to a pure nu...
`TO_PURE_NUMBER(value)`
Calculates the average of the magnitudes of deviations of data from a dataset's mean.Common quest...
`AVEDEV(value1, [value2, ...])`
Finds the weighted average of a set of values, given the values and the corresponding weights.Com...
`AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights])`
Returns the average of a range depending on multiple criteria.Common questions about the AVERAGEI...
`AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])`
Returns the value of the inverse beta distribution function for a given probability.Common questi...
`BETA.INV(probability, alpha, beta, lower_bound, upper_bound)`
`BETADIST(value, alpha, beta, lower_bound, upper_bound)`
See BETA.INVCommon Questions About the BETAINV Formula:• What is the BETAINV formula?• What does ...
`BETAINV(probability, alpha, beta, lower_bound, upper_bound)`
See BINOMDISTCommon questions about the BINOM.DIST formula include:- What is the BINOM.DIST formu...
`BINOM.DIST(num_successes, num_trials, prob_success, cumulative)`
See CRITBINOMCommon questions about the BINOM.INV formula include:- What does BINOM.INV stand for...
`BINOM.INV(num_trials, prob_success, target_prob)`
Calculates the probability of drawing a certain number of successes (or a maximum number of succe...
`BINOMDIST(num_successes, num_trials, prob_success, cumulative)`
Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.Common que...
`CHIDIST(x, degrees_freedom)`
Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.Common Ques...
`CHISQ.DIST(x, degrees_freedom, cumulative)`
Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testin...
`CHISQ.DIST.RT(x, degrees_freedom)`
Calculates the inverse of the right-tailed chi-squared distribution.Common questions about the CH...
`CHISQ.INV.RT(probability, degrees_freedom)`
See CHITESTCommon Questions about the CHISQ.TEST formula: - What does the CHISQ.TEST formula meas...
`CHISQ.TEST(observed_range, expected_range)`
Calculates the covariance of a dataset.Common questions about the COVAR formula:- What is the COV...
`COVAR(data_y, data_x)`
See COVARCommon Questions About the COVARIANCE.P Formula:1. What variables does the formula use?2...
`COVARIANCE.P(data_y, data_x)`
Calculates the covariance of a dataset, where the dataset is a sample of the total population.Com...
`COVARIANCE.S(data_y, data_x)`
Returns the minimum value in a range of cells, filtered by a set of criteria.Common questions abo...
`MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)`
Calculates the smallest value for which the cumulative binomial distribution is greater than or e...
`CRITBINOM(num_trials, prob_success, target_prob)`
Returns the value of the exponential distribution function with a specified LAMBDA at a specified...
`EXPON.DIST(x, LAMBDA, cumulative)`
See EXPON.DISTCommon questions about the EXPONDIST formula include:• What is the EXPONDIST formul...
`EXPONDIST(x, LAMBDA, cumulative)`
Calculates the left-tailed F probability distribution (degree of diversity) for two data sets wit...
`F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)`
Calculates the right-tailed F probability distribution (degree of diversity) for two data sets wi...
`F.DIST.RT(x, degrees_freedom1, degrees_freedom2)`
Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Sne...
`F.INV.RT(probability, degrees_freedom1, degrees_freedom2)`
See FTESTCommon questions about the F.TEST formula include:- What is F.TEST? - How do I use the F...
`F.TEST(range1, range2)`
See F.DIST.RTCommon questions about the FDIST formula include: - What is the formula?- What are t...
`FDIST(x, degrees_freedom1, degrees_freedom2)`
See F.INV.RTCommon Questions About the FINV Formula • What is the FINV Formula? • What does FINV ...
`FINV(probability, degrees_freedom1, degrees_freedom2)`
Returns the most commonly occurring values in a dataset.Common Questions about the MODE.MULT Form...
`MODE.MULT(value1, value2)`
Returns the inverse Fisher transformation of a specified value.Common questions about the FISHERI...
`FISHERINV(value)`

Displaying items 385-432 of 515 in total

Better Sheets