COUNTING THEN ADDING

[DMan714]

I'm having some issues coming up with the correct formula to a problem I created. The basics are this:
1. I have two separate sets of columns. Primary: (A,B,C) and Total: (E,F,G)
2. Cell E1 duplicates A1 but E2 adds E1 and A2. This is the same for B and F as well as C and G and it continues on for 70 rows.

the conundrum I am having is putting in a formula that does the following:
1. In column G: once the cell above reaches 30 then it will rest to 1 and continue to count until it reaches 30 again
2. In Column F: it does the same as G but instead of 30 it resets at 12

Here is the conundrum part: when F resets then the number in G need to increase.
For lack of better terms think of it like if it were calculating years, months, and days but instead of 30 or 31 days it is always 30

I have attached an example of what I am trying to do. Any help would be appreciated.

 

[shrivallabha]

I have not tested below logic heavily but it should point you in right direction (assuming I have understood it correctly ).

In row 3,
E3 --> =A3
F3 --> =MOD(C3,12)
G3 --> =MOD(C3,30)

In row 4
E4 --> =E3+A4+FLOOR((F3+B4)/12,1)
F4 --> =MOD(F3+B4,12)+FLOOR((G3+C4)/30,1)
G4 --> =MOD(G3+C4,30)

Formulas in row 4 shall be copied down.

 

[DMan714]

It does appear to be working. I did have to adjust the second column by one as I apparently did not mention that the 12 starts with a zero on the first cell. Thanks. it is far from done but tis will def help me along. Cheers.