Formulas within a Cell

Looking for a solution to total amounts from a range of cells with or without formulas that produce a net result.   Example:    Column A (rows of cells depicted below) 1  100.00 2    50.00 (100....