Home

HOW TO SUM TOTAL VALUE OF TWO COLUMNS

Highlighted
New Contributor

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

Please help me out !

 

4 Replies
Highlighted

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

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

But heartly thanks for your response

Highlighted

Maybe your numbers are text.

Check it by using ISNUMBER(A1).

 

Highlighted

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
Add Column Using Count
Tim Hunter in SQL Server on
0 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies