Explore a New Formula

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.

515Google Sheets Formulas

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

Returns the position at which a string is first found within text.Common questions about the FIND...
FIND(search_for, text_to_search, [starting_at])
Convert a number into a character according to the current Unicode table.The CHAR formula in Goog...
CHAR(table_number)
Returns the logical value `TRUE`.Common Questions About the TRUE Formula:1. What is the TRUE form...
TRUE()
Returns the number of empty cells in a given range.Common questions about the COUNTBLANK formula:...
COUNTBLANK(range)
Returns the numerical average value in a dataset, ignoring text.Common questions about the AVERAG...
AVERAGE(value1, [value2, ...])
Returns a count of the number of numeric values in a dataset.What are the common questions about ...
COUNT(value1, [value2, ...])
Fetches current or historical securities information from Google Finance.Common Questions About t...
GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
Returns the position at which a string is first found within text.Common questions about the SEAR...
SEARCH(search_for, text_to_search, [starting_at])
Returns the median value in a numeric dataset.Common Questions about the MEDIAN Formula:1. What i...
MEDIAN(value1, [value2, ...])
Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` ope...
EQ(value1, value2)
Checks whether a value is a valid URL.Common Questions about the ISURL Formula:1. What does the I...
ISURL(value)
Rounds a number to a certain number of decimal places, always rounding up to the next valid incre...
ROUNDUP(value, [places])
Checks whether a value is text.Common questions about the ISTEXT formula include: - What does the...
ISTEXT(value)
Calculates the number of days, months, or years between two dates.Common questions about the DATE...
DATEDIF(start_date, end_date, unit)
Rounds a number to a certain number of decimal places, always rounding down to the next valid inc...
ROUNDDOWN(value, [places])
Converts a provided year, month, and day into a date.Common questions about the DATE formula: -Wh...
DATE(year, month, day)
Translates text from one language into another.Common questions about the GOOGLETRANSLATE formula...
GOOGLETRANSLATE(text, [source_language], [target_language])
Identifies the language used in text within the specified range.Common questions about the DETECT...
DETECTLANGUAGE(text_or_range)
Returns a conditional sum across a range.Common questions about the SUMIF formula: 1. What is the...
SUMIF(range, criterion, [sum_range])
Returns a number representing the day of the week of the date provided.Common questions about the...
WEEKDAY(date, [type])
Returns the hour component of a specific time, in numeric format.Common questions about the HOUR ...
HOUR(time)
Returns the month of the year a specific date falls in, in numeric format.Common questions about ...
MONTH(date)
Returns an array of sequential numbers, such as 1, 2, 3, 4.Common questions about the SEQUENCE fo...
SEQUENCE(rows, columns, start, step)
Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `&l...
NE(value1, value2)
Replaces part of a text string with a different text string using regular expressions.Common Ques...
REGEXREPLACE(text, regular_expression, replacement)
Returns a date a specified number of months before or after another date.What are the common ques...
EDATE(start_date, months)
Converts a decimal number to signed hexadecimal format.Common Questions about the DEC2HEX Formula...
DEC2HEX(decimal_number, [significant_digits])
Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and...
IMPORTXML(url, xpath_query)
Returns the rank of a specified value in a dataset.Common questions about the RANK formula:What p...
RANK(value, data, [is_ascending])
Runs a Google Visualization API Query Language query across data.Common questions about the QUERY...
QUERY(data, query, [headers])
Counts the number of unique values in a list of specified values and ranges.Common questions abou...
COUNTUNIQUE(value1, [value2, ...])
Returns the count of a range depending on multiple criteria.Common questions about the COUNTIFS F...
COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Checks whether a formula or function is in the referenced cell.Common questions about the ISFORMU...
ISFORMULA(cell)
Returns the hyperbolic secant of the given complex number. For example, a given complex number "x...
IMSECH(number)
Calculates the depreciation of an asset for a specified period using the arithmetic declining bal...
DB(cost, salvage, life, period, [month])
Returns the values in the result range based on the position where a match was found in the looku...
XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])
Calculates the number of compounding periods required for an investment of a specified present va...
DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .
Returns the greatest common divisor of one or more integers.Common questions about the GCD formul...
GCD(value1, value2)
Returns the number of columns in a specified array or range.What are the common questions about t...
COLUMNS(range)
Returns the right portion of a string up to a certain number of bytes.Common Questions about the ...
RIGHTB(string, num_of_bytes)
Calculates the accrued interest of a security that pays interest at maturity.The ACCRINTM formula...
ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Calculates the accrued interest of a security that has periodic payments.Common questions about t...
ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])
Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.Com...
SIGN(value)
Returns the first n items in a data set after performing a sort.Common Questions about the SORTN ...
SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)
Calculates next coupon, or interest payment, date after the settlement date.Common Questions Abou...
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Calculates the payment on interest for an investment based on constant-amount periodic payments a...
IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Converts a decimal number to signed binary format.Common Questions about the DEC2BIN Formula:What...
DEC2BIN(decimal_number, [significant_digits])
Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/...
GROWTH(known_data_y, [known_data_x], [new_data_x], [b])

Displaying items 49-96 of 515 in total