sum a multi-line text and numbers cell

Ahmad ✭✭

11/19/20 edited 11/19/20 in Formulas and Functions

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

Ahmad.xlsx

0 · Share on FacebookShare on Twitter

Answers

• 

  David Tutwiler Overachievers Alumni

  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.

  0 · Share on FacebookShare on Twitter
• 

  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

  0 · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list