General discussion
June 10, 2002 at 07:07 PM
shanghai sam

Excel formula

by shanghai sam . Updated 24 years, 3 months ago

In an Excel worksheet I have four rows of data. Row A show the months January – December for 2001 and Row B shows the expenditure in each month. Row E shows the months January – December for 2002 and Row F shows the expenditure for each month.

I need to show Year-To-Date expenditure for this year and compare it with the same month’s expenditure last year – and I want it to update automatically. When I fill in June’s spend, I want it to add the total spend Jan – June 2002 and display that total in one cell, then in an adjacent cell automatically display the corresponding total for the same group of months last year.

I know there must be a formula, but……
Any help would be appreciated

Thanks – Steve

This discussion is locked

All Comments