General discussion

  • Creator
    Topic
  • #2324655

    Excel Formulas

    Locked

    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

All Comments

  • Author
    Replies
    • #3398093

      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.

      • #3584507

        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

    • #3657293

      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

    • #3584506

      Excel Formulas

      by steve-the-helpdesk ·

      In reply to Excel Formulas

      This question was closed by the author

Viewing 2 reply threads