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