Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
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)
Report
A
Anton Fedoryan, 2018-04-25
@AnnTHony

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

Similar questions
V
Vlad2016-07-04 14:51:26
How to insert a comment in an Excel formula? 1Reply
A
Almazmr2018-12-03 20:51:58
How to filter inside an excel table? 2Reply
F
Fenrir4ik2018-12-04 20:35:09
What formula can be used in Excel to calculate this? 3Reply
S
Senseich2022-02-02 14:30:42
Why does the filter work only for imported data when importing data from another file? 1Reply
M
Maxim2018-12-06 13:51:39
Why are curly brackets missing from formulas when saving a file in phpexel? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question