Sep 22 2019 12:25 PM
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
Sep 22 2019 06:31 PM
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)
Sep 24 2019 02:28 PM
THANK YOU @Wyn Hopkins this work perfectly
Sep 24 2019 02:35 PM
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