How to sum a arithmetic

Occasional Contributor


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。

3 Replies


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...

Value_G =EVALUATE(Sheet1!$G2)

Value_H =EVALUATE(Sheet1!$H2)


Then I placed this formula...

In I2




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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies