Computing.Net > Forums > Office Software > updating figures in excel 2003

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

updating figures in excel 2003

Reply to Message Icon

Name: Nabam
Date: July 28, 2009 at 03:51:03 Pacific
OS: Windows XP
CPU/Ram: pentium 4 3.00Ghz. 1gb ram
Product: Microsoft Book: office excel 2003 inside out
Subcategory: Microsoft Office
Comment:

I used to prepare monthly progress report where i have to delete the figures under monthly column whenever there is no expenditure during the month also i have to enter figures whenever there is expenditure. I want the Commulative and yearly columns kept updating the figures as shown below:

July 2009
Monthly commulative yearly
Row1 2 10 5
Row2 6 15 3

August 2009
Monthly commulative yearly
Row1 8 18 13
Row2 0 15 3


September 2009
Monthly commulative yearly
Row1 2 20 15
Row2 7 22 10 and so on ....

please help me out



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: July 28, 2009 at 03:56:41 Pacific
Reply:

I'm not sure what you are asking us to help with. It looks like you need simple SUM formulae.

Please give us some more details.


0

Response Number 2
Name: Nabam
Date: July 28, 2009 at 04:20:45 Pacific
Reply:

Derby, sum formula doesn't work here as when i delete the figures under monthly column, the figures under commulative and yearly also get reduced which i don't want and also i want the monthly figures added automatically in commulative and yearly columns whenever there is a new figure in the following months.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: updating figures in excel 2003

Excel 2007 data bars for Excel 2003 www.computing.net/answers/office/excel-2007-data-bars-for-excel-2003/9304.html

Reverse rows in Excel 2003 www.computing.net/answers/office/reverse-rows-in-excel-2003/7798.html

New macros in excel 2007 vs 2003 www.computing.net/answers/office/new-macros-in-excel-2007-vs-2003/8289.html