How Can i sum hectars ?
Best In VBA otherwise in formulas.

I have a situation like this ...

Hectars, Areas, Cent/Areas

--|----------|
| A |
--|----------|
1 | 16 47 83 |
--|----------|
2 | 23 40 30 |
--|----------|
3 | 39 88 13 |
--|----------|

Total has to be 39 88 13 ( not 06 87 113 ).



Any Help ?

Best Regards.

Robert.

On 1 Nov 2003 00:44:31 -0800, (Bubu) wrote in
microsoft.public.excel.programming:

How Can i sum hectars ?
Best In VBA otherwise in formulas.

I have a situation like this ...

Hectars, Areas, Cent/Areas

--|----------|
| A |
--|----------|
1 | 16 47 83 |
--|----------|
2 | 23 40 30 |
--|----------|
3 | 39 88 13 |
--|----------|

Total has to be 39 88 13 ( not 06 87 113 ).

How could the sum be 06 hectares? How do you get three numbers in one
column?

Assuming A1=16 B1=47 C1=83, A2=23 B2=40 C2=30, these formulae will give
you your result:
A3=SUM(A1:A2)
B3=SUM(B1:B2)+INT(SUM(C1:C2)/100)
C3=MOD(SUM(C1:C2),100)

--
Michael Bednarek, Brisbane, Australia
http://mcmbednarek.tripod.com/ "POST NO BILLS"

Just Fantastic !

What about to have Hectar.Areas.Areas/Cent in single cell ?

What about VBA Solution ?


Best Regards.

Robert.

On 1 Nov 2003 06:14:25 -0800, (Bubu) wrote in
microsoft.public.excel.programming:

Just Fantastic !

You're welcome.

What about to have Hectar.Areas.Areas/Cent in single cell ?

You presented the problem originally as if the three values were all
contained in one cell; I questioned whether that was really the case. It
seems it wasn't.

What about VBA Solution ?

It would be useful if you posted the VBA code that you already have and
in which you want to incorporate the previously posted function,
although I fail to see the need for any VBA code.

--
Michael Bednarek, Brisbane, Australia
http://mcmbednarek.tripod.com/ "POST NO BILLS"