How do I count a literal question mark in an Excel item code?
TechnologyMy practice list contains the three codes A?, AB and AX. I used `COUNTIF(A2:A4,"A?")` expecting only the first code to count, but the result includes all three. My helper wants to remove the question mark from the code so the total will behave.
Microsoft says a question mark is a wildcard in COUNTIF criteria, and a tilde can make it literal. Microsoft's COUNTIF guidance
Should I change the criterion rather than the identifier? The question mark is part of the code in this example, not an instruction to accept any final character.