I want to count the number of cells containing a number combined with a number in between brackets.
Only the number without the brackets should meet the criteria, the number in between the brackets is not relevant.
I’d like to count the cells with a value lower than 11, so the outcome should be 3. COUNTIF(A1:A5,”<11″) gives 0. What am I missing?