updating figures in excel 2003

Microsoft Book: office excel 2003 inside...
July 28, 2009 at 03:51:03
Specs: Windows XP, pentium 4 3.00Ghz. 1gb ram
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


See More: updating figures in excel 2003

Report •


#1
July 28, 2009 at 03:56:41
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.


Report •

#2
July 28, 2009 at 04:20:45
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.

Report •

Related Solutions


Ask Question