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