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
 

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