View original (French)

Adding numbers in cells with text

Solved
kawimaki -  
 kawimaki -
Hello everyone,
I’m reaching out because I haven't found the solution to my problem.
I've seen posts that were close but couldn't manage to implement it :/

I have two columns containing text and numbers, and I simply want to add the numbers together to check if the totals are correct.
Here's what I have:
Exists [3] Does not exist [223]
Exists [185] Does not exist [41]
Exists [10] Does not exist [216]
Exists [21] Does not exist [205]
Exists [6] Does not exist [220]
Exists [6] Does not exist [220]
Exists [1] Does not exist [225]
Exists [1] Does not exist [225]
Exists [1] Does not exist [225]

I would like to see the total appear in a third column.
ex.:
226
226
226
...

Is that possible?

PS: I'm also stuck because of the [ ]...

Thank you in advance and have a great day!

KM
Configuration: Windows / Chrome 101.0.4951.67

2 réponses

Réponse 1 / 2
M-12 Posted messages 1349 Status Membre 285
 
Hello,
A test with a personal function
https://www.cjoint.com/c/LEukkJPy8nF
0
kawimaki
 
Copying/pasting gives me #NAME?
Do I need to do something else?
Thank you
0
M-12 Posted messages 1349 Status Membre 285 > kawimaki
 
Re,
Of course, you need to insert the macro that can be found in the module.
0
kawimaki > M-12 Posted messages 1349 Status Membre
 
Indeed, I only work with formulas... but thanks for the help!
0
Réponse 2 / 2
ALS35 Posted messages 1034 Registration date   Status Membre Last intervention   147
 
Hello,

If your text is in A1, the following formula allows you to extract the text between brackets as a number:
=VALUE(MID(A1;FIND("[";A1)+1;FIND("]";A1)-FIND("[";A1)-1))

You can combine it on your two columns to get the sum.

Best regards
0
kawimaki
 
It works perfectly!!
Thank you very much!
0