sum a multi-line text and numbers cell

Ahmad ✭✭
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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!