How to calculate the sum of numbers in cells in Excel, but only those in the cells are in brackets?

E

Evgenia Satonina2018-04-25 16:01:16

excel

Evgenia Satonina, 2018-04-25 16:01:16

How to calculate the sum of numbers in cells in Excel, but only those in the cells are in brackets.
Example: 12(1), it's written in the cell. It is necessary that the unity be summed up.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton Fedoryan, 2018-04-25
@AnnTHony

Using array formulas
Through combination CTRL+ SHIFT+ ВВОД:
With error handling if there are no parentheses: