Forum Discussion
Solved
Wildcard characters
Hello, I just began learning the basics of Excel, and I'm kind of losing it here following this example given on the use of wildcard characters; A question mark matches any single character. An ...
- SUMIFS allows you to provide multiple criteria so in this case it will SUM all values in col A (rows 2-9) when the values in column B begin with "A" AND the valus in column C begin with "To" with 1 wildcard letter to follow.
So to answer the question criteria1 ("=A*") will 'filter' any rows that have a value in column B that doesn't start with "A"
SUMIFS allows you to provide multiple criteria so in this case it will SUM all values in col A (rows 2-9) when the values in column B begin with "A" AND the valus in column C begin with "To" with 1 wildcard letter to follow.
So to answer the question criteria1 ("=A*") will 'filter' any rows that have a value in column B that doesn't start with "A"
So to answer the question criteria1 ("=A*") will 'filter' any rows that have a value in column B that doesn't start with "A"
- Thank you, I got it!
