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