SOLVED
Home

How to sum a arithmetic

%3CLINGO-SUB%20id%3D%22lingo-sub-856011%22%20slang%3D%22en-US%22%3EHow%20to%20sum%20a%20arithmetic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856011%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131831iADCE22EB63FA9C8C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ECan%20I%20get%20the%20sum%20of%20G%20column%20and%20H%20column%20%3F%26nbsp%3B%20Which%20is%2010.190%2B5.06%2B5-0.3%2B1.6-0.3%20%3D%26nbsp%3B%20%3CSTRONG%3E21.25%E3%80%82%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-856011%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-856028%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20sum%20a%20arithmetic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398440%22%20target%3D%22_blank%22%3E%40mengsheng%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20an%20Excel%20v4.0%20macro%20function%20called%20%22EVALUATE%22%20which%20we%20can%20use%20to%20solve%20the%20equation%20you%20have%20in%20column%20G%20and%20H.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20attached%20file%2C%20I%20created%20two%20Named%20Ranges%20like%20below...%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3EValue_G%3C%2FSTRONG%3E%3C%2FU%3E%20%3CSTRONG%3E%3DEVALUATE(Sheet1!%24G2)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3EValue_H%3C%2FSTRONG%3E%3C%2FU%3E%20%3CSTRONG%3E%3DEVALUATE(Sheet1!%24H2)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20I%20placed%20this%20formula...%3C%2FP%3E%3CP%3EIn%20I2%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DValue_G%2BValue_H%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20531px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131832iF17C7DB67A3426EF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Evaluate.jpg%22%20title%3D%22Evaluate.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERemember%20to%20save%20the%20file%20as%20Excel%20Macro-Enabled%20Workbook%20since%20EVALUATE%20is%20a%20Macro%20Function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20refer%20to%20the%20attached%20for%20more%20details.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-856092%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20sum%20a%20arithmetic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856092%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGreat%20help%2C%20thank%20you.%20I%20will%20use%20the%20name%20manager%20to%20create%20the%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-856113%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20sum%20a%20arithmetic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-856113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398440%22%20target%3D%22_blank%22%3E%40mengsheng%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20welcome!%20Glad%20I%20could%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
mengsheng
Occasional Contributor

clipboard_image_0.png

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

@mengsheng 

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

Evaluate.jpg

 

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

 

Please refer to the attached for more details.

 

@Subodh_Tiwari_sktneer 

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

@mengsheng 

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