calculating row by row

D

DARKMAN

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

JLatham

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top