Wildcard Functions

The following is a list of functions that accept the wildcard characters (? and *).
Wildcard character: ? = a single character.
Wildcard character: * = multiple characters.
To include the actual wildcard characters use a tilde prefix (~?), (~*) 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.

Database

DAVERAGE	The arithmetic mean of non blank cells in a column satisfying certain conditions.
DCOUNT	The total number of non blank cells in a column satisfying certain conditions.
DCOUNTA	The total number of non blank cells in a column satisfying certain conditions (including logical values and text).
DGET	The single value in a column satisfying certain conditions.
DMAX	The largest value in a column satisfying certain conditions.
DMIN	The smallest value in a column satisfying certain conditions.
DPRODUCT	The product of values in a column satisfying certain conditions.
DSTDEV	The standard deviation of a column satisfying certain conditions based on a sample.
DSTDEVP	The standard deviation of a column satisfying certain conditions based on an entire population.
DSUM	The total of the values in a column satisfying certain conditions.
DVAR	The variance of a column satisfying certain conditions based on a sample.
DVARP	The variance of a column satisfying certain conditions based on an entire population.

DAVERAGE The arithmetic mean of non blank cells in a column satisfying certain conditions.
DCOUNT The total number of non blank cells in a column satisfying certain conditions.
DCOUNTA The total number of non blank cells in a column satisfying certain conditions (including logical values and text).
DGET The single value in a column satisfying certain conditions.
DMAX The largest value in a column satisfying certain conditions.
DMIN The smallest value in a column satisfying certain conditions.
DPRODUCT The product of values in a column satisfying certain conditions.
DSTDEV The standard deviation of a column satisfying certain conditions based on a sample.
DSTDEVP The standard deviation of a column satisfying certain conditions based on an entire population.
DSUM The total of the values in a column satisfying certain conditions.
DVAR The variance of a column satisfying certain conditions based on a sample.
DVARP The variance of a column satisfying certain conditions based on an entire population.

VBA Functions

For a list of VBA Functions that can use wildcard characters, please refer to this Wildcard Functions page.