Paul Ellery
Reputation: 1745
How do I count wildcard characters using Excel COUNTIF?
How do I count the number of cells that contain the string "A*" - without treating the star as a wildcard character?
Upvotes: 4
Views: 7679
Answers (1)
Will Bickford
Reputation: 5386
Quoted directly from Excel help documents: "If you want to find an actual question mark or asterisk, type a tilde (~) before the character."
COUNTIF(A1:A4,"A~*")
Upvotes: 11
Related Questions
- Google Spreadsheet, Count IF contains a string
- Excel COUNTIFS with wildcard on numeric data
- How do you count cells with a certain partial string?
- Excel Countif with wildcards in searched array
- Excel COUNTIF special characters
- Treating wildcards at standard characters in an INDEX(MATCH(COUNTIF())) formula
- Excel countif - how to count characters like "*", "?", "<"
- Finding numeric characters using wildcards in countif
- Trying to specify multiple wildcards in a countifs function for Excel
- How do I count not equal to wildcard characters in Excel?