cumulative total using two cells
 

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

Hi!

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

Biff

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