Ignoring values in between brackets

[E1 calling]

Hello,

I want to count the number of cells containing a value (number) combined with a number in between brackets.

Only the number without the brackets should meet the criteria, the number in between the brackets should be ignored by the formula.

Example:

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?

Thanks!

 

[E1 calling]

The formula works perfectly. Bless you, many thanks for sorting this out for me

 

[E1 calling]

Quick question: how can I measure the average position for all the numbers in each column?

All numbers between parentheses should be ignored as well as -, x and #NA. Only numbers before each parenthese should be counted in the formula.

I have been playing for a while with the formula but I am afraid I need your help again.

Is creating a formula possible? Many thanks in advance.