Wildcards
Excel functions like SUMIF and SUMIFS support thewildcardcharacters “?”
The table below shows some examples.
The tilde causes Excel to handle the next characterliterally.
For more details about using other operators in the SUMIFS function,see this page.
To read more about how this part of the formula works,see this example.
Criteria can be applied to dates, numbers, and text.
When the text is not found, FIND returns a #VALUE error.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
