Google Sheets functions

AVERAGE in Google Sheets returns the numerical mean of values and ranges while ignoring text.

COUNT in Google Sheets returns how many numeric values appear in the supplied values or ranges.

COUNTA in Google Sheets counts values in the supplied values or ranges, including numbers, text, zero-length strings, and whitespace.

MAX in Google Sheets returns the largest numeric value from the cells, ranges, or numbers you provide.

MIN in Google Sheets returns the smallest numeric value from the cells, ranges, or numbers you provide.

ROUND in Google Sheets rounds a number to a chosen number of decimal places.

SUM in Google Sheets adds numbers, cell values, and ranges into one total.

AVERAGEIF in Google Sheets calculates the mean of values associated with cells that meet one criterion.

COUNTIF in Google Sheets counts cells in one range that match a single criterion.

COUNTIFS in Google Sheets counts rows or columns where corresponding cells meet multiple criteria.

IF in Google Sheets checks a logical expression and returns one value when the expression is TRUE and another when it is FALSE.

IFERROR in Google Sheets returns a fallback value when a formula produces an error and otherwise returns the formula result.

IFS in Google Sheets evaluates several conditions in order and returns the value paired with the first condition that is TRUE.

SUMIF in Google Sheets adds values when cells in a range match one criterion.

SUMIFS in Google Sheets adds values when corresponding cells meet multiple criteria.

IMPORTRANGE in Google Sheets imports a cell range from another Google Sheets spreadsheet.

INDEX in Google Sheets returns the value at a specified row and column within a reference.

MATCH in Google Sheets returns the relative position of a search key within a one-dimensional range.

QUERY in Google Sheets runs a Google Visualization API Query Language statement across a cell range.

VLOOKUP in Google Sheets searches down the first column of a range for a key, then returns a value from a numbered column in the matching row.

XLOOKUP in Google Sheets finds a search key in one row or column and returns the value at the same position from another range.

ARRAYFORMULA in Google Sheets displays values from an array formula across multiple rows or columns and lets some non-array functions work with arrays.

FILTER in Google Sheets returns only the rows or columns from a source range that meet supplied TRUE or FALSE conditions.

SORT in Google Sheets orders the rows of a range or array by values in one or more columns.

UNIQUE in Google Sheets returns unique rows from a source range and keeps them in the order where they first appeared.

CONCATENATE in Google Sheets joins two or more strings into one text value.

LEFT in Google Sheets returns a specified number of characters from the beginning of a text string.

LEN in Google Sheets returns the number of characters in a text string, including spaces and punctuation.

MID in Google Sheets returns a chosen number of characters from the middle of a text string, beginning at a specified position.

PROPER in Google Sheets capitalizes the first letter of each word and changes the remaining letters to lowercase.

REGEXMATCH in Google Sheets checks whether text contains a part that matches a RE2 regular expression and returns TRUE or FALSE.

SPLIT in Google Sheets divides text around a delimiter and puts each fragment into a separate cell across the row.

SUBSTITUTE in Google Sheets replaces matching text inside a string with new text.

TEXT in Google Sheets converts a number, date, or time into text using a format pattern in quotation marks.

TEXTJOIN in Google Sheets combines text from values or ranges and inserts a chosen delimiter between each item.

TRIM in Google Sheets removes leading and trailing spaces and reduces repeated spaces between words to one.

DATEDIF in Google Sheets calculates the number of complete days, months, or years between two dates, with additional units for remaining month or day components.

EOMONTH in Google Sheets returns the final day of a month a specified number of months before or after a starting date.

NETWORKDAYS in Google Sheets returns the number of working days between two dates, including both endpoints and excluding Saturdays and Sundays.

TODAY in Google Sheets returns the current date as a date value without a time component.