View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DARKMAN DARKMAN is offline
external usenet poster
 
Posts: 1
Default 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.