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.
|