Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not Calculating | Excel Worksheet Functions | |||
calculating | Excel Worksheet Functions | |||
calculating age | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Not Calculating? | Excel Worksheet Functions |