Advanced Functions

AGGREGATE	The aggregate of values in a list, table or cell range.
AVERAGEIFS	The arithmetic mean of all the numbers in a range that satisfies multiple conditions.
CONVERT	The number in one measurement system converted to another.
COUNT	The number of non blank cells in a list, table or cell range.
COUNTIFS	The number of non blank cells that satisfies multiple conditions.
DATE	The date as a date serial number given a year, month, day.
DATEDIF	(Compatibility) The number of days, months or years between two dates.
EMBED	Displayed in the formula bar when an embedded object is selected.
FILTER	The array after filtering data in a range that satisfies multiple conditions.
GETPIVOTDATA	The data obtained from a pivot table.
HLOOKUP	The value in a row that matches a value in the top row of a table.
IFS	The value based on multiple True or False conditions.
INDEX	The value from a table based on an index number.
INDIRECT	The text string of the contents of a given cell reference.
LET	The result of a formula that can use variables.
LINEST	The array of values for a straight line that best fits your data.
LOOKUP	The value in a row (or column) that matches a value in a column (or row).
MATCH	The position of a value in a list, table or cell range.
OFFSET	The value in a cell which is an offset from another cell.
PERCENTILE.INC	The number corresponding to a particular percentage from an array of numbers (inclusive).
RANK.EQ	The rank of a value in a list, table or cell range (in descending order).
SUBTOTAL	The subtotal of values in a list, table or cell range.
SUM	The total value of the numbers in a list, table or cell range.
SUMIFS	The total value of the numbers that satisfies multiple conditions.
SUMPRODUCT	The sum of the product of one or more arrays of values.
UNIQUE	The array of unique values from a list, table or cell range.
VLOOKUP	The value in a column that matches a value in the first column of a table.
XLOOKUP	The value in the same row after finding a matching value in any column.
XMATCH	The position of a value in a list, table or cell range.

AGGREGATE The aggregate of values in a list, table or cell range.
AVERAGEIFS The arithmetic mean of all the numbers in a range that satisfies multiple conditions.
CONVERT The number in one measurement system converted to another.
COUNT The number of non blank cells in a list, table or cell range.
COUNTIFS The number of non blank cells that satisfies multiple conditions.
DATE The date as a date serial number given a year, month, day.
DATEDIF (Compatibility) The number of days, months or years between two dates.
EMBED Displayed in the formula bar when an embedded object is selected.
FILTER The array after filtering data in a range that satisfies multiple conditions.
GETPIVOTDATA The data obtained from a pivot table.
HLOOKUP The value in a row that matches a value in the top row of a table.
IFS The value based on multiple True or False conditions.
INDEX The value from a table based on an index number.
INDIRECT The text string of the contents of a given cell reference.
LET The result of a formula that can use variables.
LINEST The array of values for a straight line that best fits your data.
LOOKUP The value in a row (or column) that matches a value in a column (or row).
MATCH The position of a value in a list, table or cell range.
OFFSET The value in a cell which is an offset from another cell.
PERCENTILE.INC The number corresponding to a particular percentage from an array of numbers (inclusive).
RANK.EQ The rank of a value in a list, table or cell range (in descending order).
SUBTOTAL The subtotal of values in a list, table or cell range.
SUM The total value of the numbers in a list, table or cell range.
SUMIFS The total value of the numbers that satisfies multiple conditions.
SUMPRODUCT The sum of the product of one or more arrays of values.
UNIQUE The array of unique values from a list, table or cell range.
VLOOKUP The value in a column that matches a value in the first column of a table.
XLOOKUP The value in the same row after finding a matching value in any column.
XMATCH The position of a value in a list, table or cell range.