General discussion

Locked

Excel Formulas

By steve-the-helpdesk ·
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

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Formulas

by john_wills In reply to Excel Formulas

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.

Collapse -

Excel Formulas

by steve-the-helpdesk In reply to Excel Formulas

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

Collapse -

Excel Formulas

by steve-the-helpdesk In reply to Excel Formulas

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

Collapse -

Excel Formulas

by steve-the-helpdesk In reply to Excel Formulas

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums