cumulative total using two cells

B

Bill

Is it possible to have A1 cumulate to B1, A2 to B2 and so on. Each row would
stand on it's own as each row would be a different line item. I tryed to use
the two cell accumulator A1 to B1 and it worked fine, but when I applied it
to the next row (A2 to B2) and hit enter it recalcuated A1 to B1. I hope
there is a simple way to generate a formual to make this work. I need help.

Thanks

Bill
 
B

Biff

Hi!

Set calculation to manual. Enter all your data in col A
then hit F9 to calculate.

Biff
 
Top