Forum Discussion

gkmickel's avatar
gkmickel
Copper Contributor
Sep 22, 2019

Formulas . paste linked and Sum

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 su...
excel
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Sep 23, 2019

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)

  • gkmickel's avatar
    gkmickel
    Copper Contributor
    Sep 24, 2019

    THANK YOU Wyn Hopkins this work perfectly 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Sep 24, 2019

      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

       

Resources