+ Reply to Thread
Results 1 to 4 of 4

Sumif Index match with multiple column same criteria

  1. #1
    Registered User
    Join Date
    01-08-2016
    Location
    Charlottesville
    MS-Off Ver
    excel 2007
    Posts
    2

    Sumif Index match with multiple column same criteria

    Hi so I am trying to get use the index match function so that all my rows in my one column labeled with specific things like "supplies" to then add up its corresponding row in the other column expenses this is what I tried to use but it is giving me an error: =SUMIF((INDEX($B$1:$B$400)MATCH("Supplies",$E$2:$E$400, 0)))


    Any help?
    Attached Files Attached Files

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Sumif Index match with multiple column same criteria

    Enter this in H2 and fill down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Sumif Index match with multiple column same criteria

    Perhaps =SUMIF(E2:E400,"supplies",B2:B400)

  4. #4
    Registered User
    Join Date
    01-08-2016
    Location
    Charlottesville
    MS-Off Ver
    excel 2007
    Posts
    2

    Re: Sumif Index match with multiple column same criteria

    Thank you!!!

+ 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 with Multiple Criteria Using Same Criteria Column
    By rominjn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2015, 11:34 AM
  2. Sumif or Index/Match on Multiple Criteria including Dates to Month?
    By patrick1024 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2015, 11:00 PM
  3. [SOLVED] Index/Match Formula - multiple criteria in one column
    By davemon in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-19-2014, 03:00 PM
  4. [SOLVED] index match and sumproduct or sumif on multiple criteria
    By tabkaz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-02-2014, 06:20 AM
  5. [SOLVED] need help on Sumif with index and match multiple criteria
    By muheebrahman in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-11-2013, 12:53 AM
  6. Replies: 2
    Last Post: 01-27-2012, 01:32 PM
  7. Replies: 2
    Last Post: 07-22-2005, 08:05 AM

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