Adding 0 numbers

[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

 

[Andy Wiggins]

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"

 

[Gord Dibben]

"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

 

[SidBord]

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.

 

[Andy Wiggins]

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"

 

[trigz]

Thanks very much for taking a look at the problem; looks like it wil
have to remain a mystery

 

[Andy Wiggins]

No mystery - see my original reply with the answer!

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"