Excel Formulas

[CNeeds]

I have a numbers under days of month:

Days 1 2 3 4 5 6 7 8 9 10
Nums 7 9 2 5 1 1 8

I would like to add up the numbers that continue in a series in the next row.
Example: 7+9+2 = 18; 5+1=6; 1, 8
In the Row i would see: 18, 6, 1, 8

Any easy formula to achieve this???

Thanks in advance

 

[Zathras]

If you can insert a hidden row, you could set it up this way:
[tt]
A1: 'Days
B1: 1
C1: 2
D1: 3
E1: 4
F1: 5
G1: 6
H1: 7
I1: 8
J1: 9
K1: 10
A2: 'Nums
B2: 7
C2: 9
D2: 2
F2: 5
G2: 1
I2: 1
K2: 8
A3: 'Work
B3: =B2
C3: =IF(C2,B3+C2,0)
copy C3 to D3:K3
A4: 'Running Total
B4: =IF(C3=0,B3,"")
copy B4 to C4:K4
[/tt]
Hide row 3