Wildcard Functions
The following is a list of functions that accept the wildcard characters (? and *).
One or More 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. |
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
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. |
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
SEARCH | The position of a substring within a larger text string. |
SEARCH The position of a substring within a larger text string. |
VBA Functions
For a list of VBA Functions that can use wildcard characters, please refer to this Wildcard Functions page.
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext