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....
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
- My Excel version is now updated and I have access to the LET function, I need to add date parameters to filter to range of cells that may or may not have a subtraction formula within the cell. Can you provide an example of how to add these additional criteria into the formula you previously provided? Thank you.