• 464K Members
• 11.3K Online
• 561K Conversations
SOLVED

## How to sum a arithmetic

Occasional Contributor

# How to sum a arithmetic

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
Solution

# Re: How to sum a arithmetic

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

=Value_G+Value_H

Remember to save the file as Excel Macro-Enabled Workbook since EVALUATE is a Macro Function.

Please refer to the attached for more details.

# Re: How to sum a arithmetic

Great help, thank you. I will use the name manager to create the function.

# Re: How to sum a arithmetic

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