How to =SUM a column with GB and TB size values?

I am looking to get a total for a column that is using GB and TB data sizes. Is there a way to use the =SUM formula to find the total?

Ex:

3.91TB

3.21TB

5.8GB

7.3GB

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!