need help with sum

[floweris]

Hy there,
can anyone help me with the problem i just met...
I need to count values from column A one one by one. result is in column B... and im doing it with =SUM(A$1:A1). But, the thing is that i need to count again numbers when the sum is not more than 9... (the result im looking for ir in a column C,D,E....

[bebo021999]

Try:

In C1:

=A1

C2 then drag down:

=IF(C1="","",IF(C1+A2<=9,C1+A2,""))

D2 then drag down and across:

=IF(SUM($C2:C2)>0,"",IF(SUM(D$1:D1)>0,IF(D1="","",IF(D1+$A2<=9,D1+$A2,"")),$A2))

[Czeslaw]

Use the "Solver"