Sum a multi-line text and numbers cell

[ahmadhassan]

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

[Bo_Ry]

Please try

Please Login or Register  to view this content.

normal enter

or

Please Login or Register  to view this content.

Ctrl+Shift+Enter

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[ahmadhassan]

Please try

Thanks bro, this work fine
Can give me little explain for this formula

[6StringJazzer]

Further responses before this administrative direction is fulfilled will result in infractions.

[ahmadhassan]

Further responses before this administrative direction is fulfilled will result in infractions.

Hello String,
I ask this question on another site before write here and not received any solution because that I asked here.
https://community.smartsheet.com/discussion/comment/269487#Comment_269487

[Glenn Kennedy]

Thanks adding links to the cross-post. Next time, please remember to provide any/all such links from the start.

[6StringJazzer]

I ask this question on another site before write here and not received any solution because that I asked here.

It is fine to post on another site. If you do we require that you give the link here. Because you have been a member for 5 years you should be familiar with our rules. The other site may have the same requirement.

Shukrun,