# 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. |

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. |

### 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. |

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. |

### Text

SEARCH | The position of a substring within a larger text string. |

SEARCHThe 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. |

DAVERAGEThe arithmetic mean of non blank cells in a column satisfying certain conditions. |

DCOUNTThe total number of non blank cells in a column satisfying certain conditions. |

DCOUNTAThe total number of non blank cells in a column satisfying certain conditions (including logical values and text). |

DGETThe single value in a column satisfying certain conditions. |

DMAXThe largest value in a column satisfying certain conditions. |

DMINThe smallest value in a column satisfying certain conditions. |

DPRODUCTThe product of values in a column satisfying certain conditions. |

DSTDEVThe standard deviation of a column satisfying certain conditions based on a sample. |

DSTDEVPThe standard deviation of a column satisfying certain conditions based on an entire population. |

DSUMThe total of the values in a column satisfying certain conditions. |

DVARThe variance of a column satisfying certain conditions based on a sample. |

DVARPThe 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.

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