well, manually you could type in cell F1

=sum(a1:e1)

and then use the fill handle to drag it down your 15000 rows. it will
automatically adjust for each row.


you could also use a macro. right click on your sheet tab, choose
"view code" and then paste this:

Sub Luchian()

Dim myRange As Range
Dim c As Range

Set myRange = ActiveSheet.Range("f1:f15625")

For Each c In myRange
c.Formula = "=sum(a" & c.Row & ":e" & c.Row & ")"
Next c

End Sub


hope it helps!
:)
susan


On Oct 7, 2:20*pm, Luchian wrote:
Please help on this:
I have 5 colomn with 6 row with number 1 or 0

A * *B * *C * * D * * E
0 * *1 * * 0 * * 1 * * 1
1 * *0 * * 0 * * 1 * * 1
1 * *1 * * 1 * * 0 * * 0
0 * *0 * * 0 * * 0 * * 0
0 * *1 * * 1 * * 0 * * 0
1 * *1 * * 1 * * 0 * * 1

It's possibile to generate in column F all possibile results if sum one cell
in every row. If i make simple formula (add one cell in everry row, one by
one) *will look like that:

F
A1+A2+A3+A4+A5+A6
A1+A2+A3+A4+A5+B6
...
A1+A2+A3+B4+B5+B6
...
B1+A2+A3+A4+B5+B6
...
B1+C2+A3+D4+B5+E6
...
E1+E2+E3+E4+E5+E6 *

It was 15625 (5^) formulas to insert . Can i GENERATE ALL THIS SUMS
automatically?