Questions

# What is the Formula for calculating cumulative/progressive data in excel?

Locked

### What is the Formula for calculating cumulative/progressive data in excel?

I want to have one sheet where I will put the daily sales data, so that progressive data will be automatically be created.For e.g. in A column the date will be entered. in B column today's sale will be entered. I want that column C should generate the progressive value automatically.

### Have I missed something?

Put a zero in C1.Put "= C 1 + B2" in C2. Copy C2 to the rest of the column: it will automatically get corrected to "= C2 + B3" etc At least that's how Works works..

### tutorials are a wonderful tool for homework

have a look here... http://www.theexceladdict.com/_t/t040512.htm and remember, google is your friend

### Reponse To Answer

Thanks a lot.

### I can't point fingers!

Going back to 1981 and my first Apple with dBASE III, it took me three months to discover how to process a file sequentially. V1 of my time-clocking by job took 8 hours to complete, V2 took under 3 minutes!

### Have I missed something?

Put a zero in C1.Put "= C 1 + B2" in C2. Copy C2 to the rest of the column: it will automatically get corrected to "= C2 + B3" etc At least that's how Works works..

### tutorials are a wonderful tool for homework

have a look here... http://www.theexceladdict.com/_t/t040512.htm and remember, google is your friend