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

E

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?

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

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:

Similar questions

I

Ilya Magdenko2019-09-18 13:58:44

How to transpose such a structure in Excel 2007? 0Reply

S

Skripich2019-09-18 23:18:17

How to make a regular expression "find everything up to the FIRST character, ignoring the rest"? 1Reply

P

Pavel2021-04-05 15:26:35

How to get full name from full text in VBA excel? 1Reply

G

Groofy2017-04-26 12:12:25

How to paste copied value into Cells.Replace What:="? 1Reply

J

John Smith2021-04-09 21:05:21

Formatting percentages in Excel so that the % symbol is to the right? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question