Adding 0 numbers

  • Thread starter Thread starter trigz
  • Start date Start date
T

trigz

As part of a test my niece was given the following task to do:-

3 numbers were placed in 3 different cells in a column:-

0,062
0,042
0,022

and she was asked to use Excel to calculate the total of these
numbers( = SUM).

She couldnt do it and I cant.

Is it possible?

Thanks very much
 
If the numbers are in, say, cells A1, A11 and A111 then you can use the
following SUM formulas in, say, cell B1:

=SUM(A1,A11,A111)
=SUM(A:A)
=SUM(A1:A111)

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
"couldn't" and "can't" means what?

How are you trying to achieve the calculation?

Do you get any error message?

Do you get a zero when you use =A1+B1+G4 or =SUM(A1:A3) or some such formula?

Could be the numbers are text.

Gord Dibben Excel MVP
 
I'm suspicious of the format you showed like "0,062".
One wonders how a cell with a number format can display
such a number (Excel likes to throw away leading zeros).
When I tried it, I used the formula evaluator to step thru
the sequence of addition, and it displayed each number with
quotes around it ("0,062") suggesting that the system was
treating it as a text string. I defined each cell to be a
number, then re-entered each number, but still got the same
result. Apparently the comma is doing you in.
 
Format > Cells > Number : in Category, select Custom, then in Type put
0,000. this will display as, e.g. 0,012

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Thanks very much for taking a look at the problem; looks like it wil
have to remain a mystery
 
Back
Top