How Can i sum hectars ?

  • Thread starter Thread starter Bubu
  • Start date Start date
B

Bubu

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.
 
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 ).
Click to expand...

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)
 
Just Fantastic !

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

What about VBA Solution ?


Best Regards.

Robert.
 
Just Fantastic !
Click to expand...

You're welcome.
What about to have Hectar.Areas.Areas/Cent in single cell ?
Click to expand...

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 ?
Click to expand...

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.
 
Back
Top