Forum Discussion

null null's avatar
null null
Copper Contributor
May 17, 2018

HOW TO SUM TOTAL VALUE OF TWO COLUMNS

Always when i sum two large no. using the formula [=SUM(:)] it gives '0' as output.  Please help me out !  
Formulas & Functions
tips and tricks
Logaraj Sekar's avatar
Logaraj Sekar
Steel Contributor
May 17, 2018

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)

 

null null's avatar
null null
Copper Contributor
May 17, 2018

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

But heartly thanks for your response

  • Logaraj Sekar's avatar
    Logaraj Sekar
    Steel Contributor
    May 18, 2018

    Hi null null,

     

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

     

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    May 18, 2018

    Maybe your numbers are text.

    Check it by using ISNUMBER(A1).