Tuesday, September 18, 2012

yogi_Sum Up Numbers In One Or More Lines Within A Single Cell

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #759   Sep 18, 2012     www.energyefficientbuild.com.

user Mrs.eM said: (http://productforums.google.com/forum/?zx=moicavc8fpfc#!category-topic/docs/spreadsheets/GMGG_cApa4k)
SUM multiple numbers within a single cell

Hello,
I have multiple numbers listed in a single cell seperated by text.
How can I total the numbers without seperating the text into a different cell?
 
Example:
2,500 sq. ft. - H&R Block
24,000 sq. ft. - Tattoo Parlor
30,000 sq. ft. - Barber Shop
 
Thank you.
---------------------------------------------------------------------------------------
following is a solution to the problem