+ Reply to Thread
Results 1 to 2 of 2

sum index match more than the first return

  1. #1
    Registered User
    Join Date
    07-01-2013
    Location
    Tomahawk, WI
    MS-Off Ver
    Excel 2010
    Posts
    2

    sum index match more than the first return

    I currently have an equipment spending schedule (percentage) broken down into each quarter and year. For each piece of equipment I want to break down the spending by quarter. See the attached spreadsheet.

    I used the index and match functions, but it is only going to the first value, and I want it to sum all the values. I know I am missing something here, but I do not know what to do.

    Q2 2013 should be 15%, Q3 2013 should be 50%, and so on. I've tried using sumif(), but couldn't get that to work either. Any help would be appreciated!

    QuarterlySpendingForecast.xlsx

  2. #2
    Registered User
    Join Date
    07-01-2013
    Location
    Tomahawk, WI
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: sum index match more than the first return

    sumif works just fine. I got too complicated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1