sum a multi-line text and numbers cell

Ahmad · 11/19/20

Hello all,

I have a sheet need sum number in multiline cell like:

A1 = 80 GB

A2 = 100 GB and 1 TB

A3 (Total) = 1180 GB or 1.18 TB

David Tutwiler · 11/19/20

Is there any way to clean up the input coming into this sheet? If you just standardized the input in GB then you could just do a simple sum and then a division that would show your TB at the end.

Ahmad · 11/19/20

https://community.smartsheet.com/discussion/comment/269487#Comment_269487

I knot that bro, but this simple of file I have

and also I can use =SUMPRODUCT(--SUBSTITUTE(I4,"GB","")) and the same with change GB to TB

But also need sprite GB and TB to 2 Colum

sum a multi-line text and numbers cell

Answers

Help Article Resources

Categories