Countif and bracket in cell


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.


A1: 7(+1)

A2: 12(-3)

A3: 15(+2)

A4: 9(+8)

A5: 4(-1)

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?


Leave a Reply

Your email address will not be published. Required fields are marked *