• 595K Members
• 12.8K Online
• 722K Conversations

Highlighted
New Contributor

# HOW TO SUM TOTAL VALUE OF TWO COLUMNS

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

4 Replies
Highlighted

# Re: HOW TO SUM TOTAL VALUE OF TWO COLUMNS

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

Highlighted

# Re: HOW TO SUM TOTAL VALUE OF TWO COLUMNS

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

But heartly thanks for your response

Highlighted

# Re: HOW TO SUM TOTAL VALUE OF TWO COLUMNS

Check it by using ISNUMBER(A1).

Highlighted

# Re: HOW TO SUM TOTAL VALUE OF TWO COLUMNS

Hi @null null,

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

Related Conversations
Restrict Edit access on columns on user/group basis.
Vimmi Rawat in SharePoint on
0 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
Tim Hunter in SQL Server on
0 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies