hi all

i'm having a small problem

i have many cells in my sheet with this text :

"free space in this rack : 19 U"

"free space in this rack : 7 U"

"free space in this rack : 0 U"

etc...

and i wanna have a cell with the sum of all the numbers like this :

"total space in all racks : XX U"

(or "total space in all racks (in U) : " and another cell with the result "XX" if its more simple)

i don't know anything about excel formulas, i tried some small things like SUM, SUMIF, RIGHT etc.. but can't manage to do it.

is there a way of doing it easily ?

cells are C47 to Q47 (and i'll put the total in I57 for example)

in fact i just wanna sum the numbers (and forget the text), so maybe there's a simple command to "ignore" the text ?

regards,

thanks

i'm having a small problem

i have many cells in my sheet with this text :

"free space in this rack : 19 U"

"free space in this rack : 7 U"

"free space in this rack : 0 U"

etc...

and i wanna have a cell with the sum of all the numbers like this :

"total space in all racks : XX U"

(or "total space in all racks (in U) : " and another cell with the result "XX" if its more simple)

i don't know anything about excel formulas, i tried some small things like SUM, SUMIF, RIGHT etc.. but can't manage to do it.

is there a way of doing it easily ?

cells are C47 to Q47 (and i'll put the total in I57 for example)

in fact i just wanna sum the numbers (and forget the text), so maybe there's a simple command to "ignore" the text ?

regards,

thanks

Last edited: