HOW TO SUM TOTAL VALUE OF TWO COLUMNS

[null null]

Always when i sum two large no. using the formula [=SUM(:)] it gives '0' as output. 

Please help me out !

[#2]

Hi,

Let me now length of values.

Use anyone of folloiwng, if you sum only two large numbers.

=6778978987+676768767
=A2+79789489161
=A2+B2
=SUM(A2:B2)
=SUM(A2,B2)
=SUM(6789461654,874615467)
=SUM(9879874615,B2)

Dont use. For (eg.)

=sum(67978978:46546987)

[#3]

I've tried that one too, but still the output comes zero

But heartly thanks for your response

[#4]

Maybe your numbers are text.

Check it by using ISNUMBER(A1).

[#5]

Hi @null null,

Make sure that doesn't contains spaces or anything else.