Forum Discussion
Question related to sum(Text with Number)
Hello Everyone, I want to sum text with number. Like - IN COLUMN - IN ROW - The answer should be come in cell just written sheet with the help of formula Please help.? ...
There are many roads that lead to Rome, here is another approach.
Formula inserted in the file.
=SUMME(RECHTS(B1:B6;FINDEN(" ";B1:B6)-1)*1) in German
=SUM(RIGHT(B1:B6,FIND(" ",B1:B6)-1)*1) in English
=SOMME(DROITE(B1:B6;TROUVE(" ";B1:B6)-1)*1) in French
Contains array formula:
Do not enter the border {}, complete the formula with CTRL + SHIFT + RETURN!
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Thank you so much sir.
Sir, why you put *1? Please explain
Sir, why you put *1? Please explain