Forum Discussion
Asterisk doesn't represent any random character
Hi all, I want to count all cells that start with '50' (see A7) in sheet Test scenarios_UR, column C. Result should be 9, and not 1. According the documentation, the asterisk symbol represents any ...
Keep your data as is and use REGEXTEST:
=SUM(--REGEXTEST(A1:A10,"^50"))The "^50" is regex's way of checking for 50 at the start of the string.