Forum Discussion
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....
As variant
Anvances:
=LET(
range, A1:A4,
str, SUBSTITUTE( FORMULATEXT(range), "=", "" ),
pos, FIND( "-", str ),
SUM( IFNA( --LEFT( str, pos -1 ), range ) ) )
Payments:
=LET(
range, A1:A4,
str, SUBSTITUTE( FORMULATEXT(range), "=", "" ),
pos, FIND( "-", str ),
-SUM( IFNA( --RIGHT( str, LEN(str) - pos ), 0 ) ) )
Thank you for your solution.
Can this be accomplished using existing Excel functions without using VBA?
That's not VBA, that's existing LET function (microsoft.com) . Availability depends on your Excel version and platform.
- OK, I see that now, I'm a version behind but will upgrade and put your solution into practice. Thank you!
deschroeder , you are welcome