Software

Ask something
Discussion Locked

Excel Formulas

0 helpful
4 replies

by steve-the-helpdesk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have four rows of data on an Excel sheet. Row 1 contains months for the year 2001. Row 2 contains expenditure for each month.
Row 4 contains months for 2002 and row 5 contains expenditure for each month.

I need to show Year-To-Date figures forboth years but to update them automatically. When I input the total spend for June, I want one cell to display the total spend for the year 2002, January - June. I then want an adjoining cell to automatically display the January - June figure for 2001.

When I enter the July 2002 spend, I want the 2001 total to update automatically.

I have looked at all sorts of info about array constants, but cannot find one that will do what I want.

Any help would be appreciated.

Thanks - Steve

4 replies

by john_wills

This looks to be a parallel to the "Excel formula" problem submitted bu User deleted one place below this in the list of questions. See if my answer there helps.

by steve-the-helpdesk

Hi, John,
I thought I had better close this one off. Sorry but your answer did nothing for my problem. I'm still trying to get this 'sliding formula' set up. Perhaps Jeff Davis is watching - he seems to have the answers to most MS Office questions.;-)
For being the only respondent - please have the points with my compliments.
Stay Sane
Steve

by steve-the-helpdesk

Hi, John,
You are right, this is the same as the other question. I posted the first one and discovered that, for some reason, user deleted had been used. Don't know why.

Thanks for your suggestion - i guess I wasn't too clear in what I wanted toachieve - the Year to Date part is fairly straightforward, it's the 'rolling' aspect of it that has been causing me grief. Getting Excel to read the number of months with expenditure for this year, calculating a total for that set of months, then totalling the same months for last year, but doing it automatically. Any ideas?

Steve

This discussion is closed to new replies.