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 sum formula to read these cells as values so it will add them?

thank you 

excel

3 Replies

  • 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)

      • 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