Advanced Functions

AGGREGATEThe aggregate of values in a list, table or cell range.
AVERAGEIFSThe arithmetic mean of all the numbers in a range that satisfies multiple conditions.
CONVERTThe number in one measurement system converted to another.
COUNTThe number of non blank cells in a list, table or cell range.
COUNTIFSThe number of non blank cells that satisfies multiple conditions.
DATEThe date as a date serial number given a year, month, day.
DATEDIF(Compatibility) The number of days, months or years between two dates.
EMBEDDisplayed in the formula bar when an embedded object is selected.
FILTERThe array after filtering data in a range that satisfies multiple conditions.
HLOOKUPThe value in a row that matches a value in the top row of a table.
IFSThe value based on multiple True or False conditions.
GETPIVOTDATAThe data obtained from a pivot table.
INDEXThe value from a table based on an index number.
INDIRECTThe text string of the contents of a given cell reference.
LETThe result of a formula that can use variables.
LINESTThe array of values for a straight line that best fits your data.
LOOKUPThe value in a row (or column) that matches a value in a column (or row).
MATCHThe position of a value in a list, table or cell range.
OFFSETThe value in a cell which is an offset from another cell.
PERCENTILE.INCThe number corresponding to a particular percentage from an array of numbers (inclusive).
RANK.EQThe rank of a value in a list, table or cell range (in descending order).
SUBTOTALThe subtotal of values in a list, table or cell range.
SUMThe total value of the numbers in a list, table or cell range.
SUMIFSThe total value of the numbers that satisfies multiple conditions.
SUMPRODUCTThe sum of the product of one or more arrays of values.
VLOOKUPThe value in a column that matches a value in the first column of a table.
XLOOKUPThe value in the same row after finding a matching value in any column.
XMATCHThe 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.
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.
GETPIVOTDATA
The data obtained from a pivot table.
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.
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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext