Wildcard Functions

The following is a list of functions that accept the wildcard characters (? and *).


One or More Conditions

AVERAGEIFThe arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFSThe arithmetic mean of all the numbers in a range that satisfies multiple conditions.
COUNTIFThe number of non blank cells that satisfies one condition.
COUNTIFSThe number of non blank cells that satisfies multiple conditions.
MAXIFSThe largest value in a list or array of numbers that satisfies multiple conditions.
MINIFSThe smallest value in a list or array of numbers that satisfies multiple conditions.
SUMIFThe total value of the numbers that satisfies one condition.
SUMIFSThe total value of the numbers that satisfies multiple conditions.
AVERAGEIF
The arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFS
The arithmetic mean of all the numbers in a range that satisfies multiple conditions.
COUNTIF
The number of non blank cells that satisfies one condition.
COUNTIFS
The number of non blank cells that satisfies multiple conditions.
MAXIFS
The largest value in a list or array of numbers that satisfies multiple conditions.
MINIFS
The smallest value in a list or array of numbers that satisfies multiple conditions.
SUMIF
The total value of the numbers that satisfies one condition.
SUMIFS
The total value of the numbers that satisfies multiple conditions.

Lookup and Reference

MATCHThe position of a value in a list, table or cell range.
VLOOKUPThe value in the same row after finding a matching value in the first column.
HLOOKUPThe value in the same column after finding a matching value in the first row.
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.
MATCH
The position of a value in a list, table or cell range.
VLOOKUP
The value in the same row after finding a matching value in the first column.
HLOOKUP
The value in the same column after finding a matching value in the first row.
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.

Text

SEARCHThe the position of a substring within a larger text string.
SEARCH
The the position of a substring within a larger text string.

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