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 ...
The * only works in the context of (datatype) text. The formula only picks up the value in C6.
Either you change your criteria to numbers or the data to text.