calculating row by row
 

I would like to have Excel total the sum of a row 5 of randomly generated
numbers in a 6th column, one column at a time.
I have no problem generating the random numbers and totalling them but I
would like to generate the first number and place it in the total column then
when I initiate it generate the second number, add this to the first and
place it in the total and so on to the 5th column. Is this possible?

Many thanks.

calculating row by row
 

Unless I'm missing something here, this formula should do it for you. This
is for row 2 on the sheet, and would go into cell F2
=SUM(A2:E2)
That formula will "fill" down the sheet automatically adjusting to total the
values in columns A through E on each row. See Excel Help for Fill Data for
information on filling formulas and data on a worksheet if you need help with
that part of it.


"DARKMAN" wrote:

I would like to have Excel total the sum of a row 5 of randomly generated
numbers in a 6th column, one column at a time.
I have no problem generating the random numbers and totalling them but I
would like to generate the first number and place it in the total column then
when I initiate it generate the second number, add this to the first and
place it in the total and so on to the 5th column. Is this possible?

Many thanks.