+ Reply to Thread
Results 1 to 2 of 2

Sum Multiple Rows with an Index/Match

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    Chicago
    MS-Off Ver
    O365
    Posts
    311

    Sum Multiple Rows with an Index/Match

    Hello,

    I have a data set that has tenants listed down column A. In the columns to the right I have 13 months. December PY through December current year. The columns house the tenants square footage by month. If a tenant..say Apple expires in March and renews I would see that tenant on two lines in the data. December PY through March would have the square footage say 1000 a month. The remainder of the year would be zero. The second line they fall on would have April for 1000 through December for 1000. I am using an index match on another tab where I only have the tenant on one row and need the formula to pull Apple 1000 for December prior year through December current year. The index match finds the first instance so I am missing April through December.

    =INDEX(JDESqFtg!$A:$Z,MATCH('RE Tax Cntrb Sched'!$C19,JDESqFtg!$Z:$Z,0),MATCH('RE Tax Cntrb Sched'!J$10,JDESqFtg!$6:$6,0))

    Is there a way to tell it to search and find the first match and add it to the second match and so on? Or would the SUMIFS work better?

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Sum Multiple Rows with an Index/Match

    SUMIFS should do it
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] INDEX/MATCH (multiple critera in multiple rows and columns)
    By swma in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-01-2016, 10:02 AM
  2. [SOLVED] INDEX+MATCH with multiple criteria across both rows and columns
    By george_k in forum Excel General
    Replies: 3
    Last Post: 10-26-2012, 04:11 PM
  3. Index and Match with multiple columns/rows
    By fab121 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2012, 02:33 PM
  4. [SOLVED] Index and Match Multiple Header (Rows) Criteria
    By dluhut in forum Excel General
    Replies: 7
    Last Post: 04-12-2012, 06:25 PM
  5. Vlookup and Index/Match problem with multiple rows
    By excelismyfriend in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-01-2009, 12:25 PM

Tags for this Thread

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