cumulative sales

[kish_gv]

Please help me in the following query, my excel table contains three columns customer(Column A), Daily sales (Column B), Cumulative Sales ( column C).
I enter daily sales made to customers and taking previous sales in column c i add daily sales to arrive cumulative sales . This i have to repeat to n number of customers. Is there any other way to save my time so that cumulative sales is calcuated automatically when i give daily sales.

[royUK]

What version of Excel are you using?

You can enter a formula to do this, if you are using Excel 2003 then use the Data menu . Lists feature

http://www.excel-it.com/excel2003_lists.htm

If not then make sure that you have the the Extend data range formats & formulas option checked in the Tools menu > Options > Edit. The formula should then add itself to each row as you enter data.

[kish_gv]

I dont know exactly how to revert back. Please help me the problem i am having i thought lets put in some elaborative way and has added a new thread.
Excuse for that. I had checked the site.Please give me soultion.

[royUK]

I've given you a way to do this, have you tried it.

Try answering my question - What version of Excel are you using?

[kish_gv]

Its Excel-2002. I check out your website and as told by you the options externed formula is also enabled. Please do help me

[royUK]

can you attach a small example workbook?

[kish_gv]

Dear Sir,

I was on vacation and please find attachment where i give problem right now i am facing.
Please help me.

[lalbatros]

Have you considered dropping column C, and using pivottables for analysing these data?

[royUK]

If you want help then please read what helpers suggest -
attach a workbook example!