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 answers

  1.
    M-12 Posted messages 1349 Status Member 285
     
    Hello,
    A test with a personal function
    https://www.cjoint.com/c/LEukkJPy8nF
    0
    1. kawimaki
       
      Copying/pasting gives me #NAME?
      Do I need to do something else?
      Thank you
      0
      1. M-12 Posted messages 1349 Status Member 285 > kawimaki
         
        Re,
        Of course, you need to insert the macro that can be found in the module.
        0
      2. kawimaki > M-12 Posted messages 1349 Status Member
         
        Indeed, I only work with formulas... but thanks for the help!
        0
  2. ALS35 Posted messages 1034 Registration date   Status Member 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
    1. kawimaki
       
      It works perfectly!!
      Thank you very much!
      0