+ Reply to Thread
Results 1 to 4 of 4

SUMIFS with AND & INDEX & MATCH

  1. #1
    Forum Contributor
    Join Date
    08-22-2013
    Location
    columbus,oh
    MS-Off Ver
    Office 365
    Posts
    190

    SUMIFS with AND & INDEX & MATCH

    I need to be able to do a sumif based on 2 conditions and am not sure how to use AND in this situation.
    I want to do a sumif if the group is Under26 and Price Band is 250-500 then add based on match using the column header.

    I have attached a sample workbook done with 1 condition .

    Thanks!Sample1.xlsx

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: SUMIFS with AND & INDEX & MATCH

    You can just add another criteria to the existing sumifs..

    In C11:
    =SUMIFS(INDEX('SKU Details'!$A$32:$VY$2003,0,MATCH(C$10,'SKU Details'!$A$23:$VY$23,0)),'SKU Details'!$T$32:$T$2003,$A11,'SKU Details'!$O$32:$O$2003,$B11)

  3. #3
    Forum Contributor
    Join Date
    08-22-2013
    Location
    columbus,oh
    MS-Off Ver
    Office 365
    Posts
    190

    Re: SUMIFS with AND & INDEX & MATCH

    That worked ! Thank you!

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: SUMIFS with AND & INDEX & MATCH

    You're welcome.

+ 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. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  2. [SOLVED] Index Match from a cell populated from index match
    By MarcLewis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-15-2013, 05:30 AM
  3. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  4. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  5. Replies: 5
    Last Post: 02-29-2012, 08:51 PM

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