Ways to use the string operator and wildcards
The string operator (&) can be used in formulas, and wildcards (*,?,~) can be used…
Functions that accept conditions and wildcards as arguments
Some functions, such as SUM, operate on entire ranges. Other functions, such as SUMIF, operate…