Can I get the sum of G column and H column ? Which is 10.190+5.06+5-0.3+1.6-0.3 = 21.25。
View best response
There is an Excel v4.0 macro function called "EVALUATE" which we can use to solve the equation you have in column G and H.
In the attached file, I created two Named Ranges like below...
Then I placed this formula...
Remember to save the file as Excel Macro-Enabled Workbook since EVALUATE is a Macro Function.
Please refer to the attached for more details.
Great help, thank you. I will use the name manager to create the function.
You're welcome! Glad I could help.