Forum Discussion

null null's avatar
null null
Copper Contributor
May 18, 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 18, 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 18, 2018

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

      But heartly thanks for your response

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

        Maybe your numbers are text.

        Check it by using ISNUMBER(A1).

         

Resources