Home

Formulas . paste linked and Sum

%3CLINGO-SUB%20id%3D%22lingo-sub-869365%22%20slang%3D%22en-US%22%3EFormulas%20.%20paste%20linked%20and%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869365%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20column%20of%20numbers%20in%20cells%20that%20I%20have%20copied%20and%20paste%20linked%20into%20each%20cell%20from%20another%20sheet.%20I%20would%20like%20to%20now%20add%20up%20these%20cells%20and%20it%20will%20not%20add%20them.%20How%20do%20I%20get%20the%20sum%20formula%20to%20read%20these%20cells%20as%20values%20so%20it%20will%20add%20them%3F%3C%2FP%3E%3CP%3Ethank%20you%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-869365%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-869599%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20.%20paste%20linked%20and%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869599%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413272%22%20target%3D%22_blank%22%3E%40gkmickel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20can%20post%20a%20sample%20of%20the%20file%20that%20would%20be%20great.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20%22numbers%22%20are%20actually%20text%20you%20could%20refer%20to%20them%20within%20a%20VALUE%20function%20to%20convert%26nbsp%3B%20so%26nbsp%3B%20%26nbsp%3B%3DVALUE(A1)%20%2B%20VALUE(A2)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873424%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20.%20paste%20linked%20and%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873424%22%20slang%3D%22en-US%22%3E%3CP%3ETHANK%20YOU%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3Bthis%20work%20perfectly%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-873436%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20.%20paste%20linked%20and%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-873436%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413272%22%20target%3D%22_blank%22%3E%40gkmickel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20a%20comment%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3D1%20%2B%202%20%20%20%20%20%20%20%20%20%20%20%20%20%20returns%203%0A%3D%221%22%20%2B%20%222%22%20%20%20%20%20%20%20%20%20%20returns%203%0A%3DSUM(%221%22%2C%222%22)%20%20%20%20%20%20%20returns%200%0A%3DSUM(--%221%22%2C--%222%22)%20%20%20returns%203%0A%3DSUM(VALUE(%221%22)%2CVALUE(%222%22))%20%20%20returns%203%0A%0A%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
gkmickel
New Contributor

I have created a column of numbers in cells that I have copied and paste linked into each cell from another sheet. I would like to now add up these cells and it will not add them. How do I get the sum formula to read these cells as values so it will add them?

thank you 

3 Replies

Hi @gkmickel 

If you can post a sample of the file that would be great.

 

If the "numbers" are actually text you could refer to them within a VALUE function to convert  so   =VALUE(A1) + VALUE(A2)

THANK YOU @Wyn Hopkins this work perfectly 

@gkmickel 

As a comment

=1 + 2              returns 3
="1" + "2"          returns 3
=SUM("1","2")       returns 0
=SUM(--"1",--"2")   returns 3
=SUM(VALUE("1"),VALUE("2"))   returns 3

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies