Thread: How Can i sum hectars ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Bednarek[_3_] Michael Bednarek[_3_] is offline
external usenet poster
  
Posts: 18
Default How Can i sum hectars ?
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"
Reply With QuoteReply With Quote