Results 1 to 13 of 13

Need help with INDEX,MATCH & SUM formula

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Need help with INDEX,MATCH & SUM formula

    Hello:

    Please refer to the attached sheet with sample data.
    Sheet1 has some data which is used in Sheet2 to Summarize the quantity of each item used.

    I am using formula
    {=IFERROR(INDEX(Sheet1!$G$1:$G$20000,MATCH(1,IF(Sheet1!$E$1:$E$20000=D$2,IF(Sheet1!$D$1:$D$20000=$A4,IF(Sheet1!$A$1:$A$20000=$A$1,1))),0)),"")}
    The result i wanted to see was -2+7=+5 in cell D5 of sheet2.
    I am not sure if this formula is wrong.
    Please help correct the formula which is in cell D4:D

    Please let me know if any questions.

    Thank you

    Riz Momin
    Attached Files Attached Files
    Last edited by rizmomin; 09-07-2013 at 05:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula that counts rows that match 2 criteria, but do not match another
    By VivatMartin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 07:43 AM
  2. Replies: 5
    Last Post: 02-29-2012, 08:51 PM
  3. Replies: 2
    Last Post: 12-09-2011, 07:17 PM
  4. Nested Match(index()) vs. Match() array formula.
    By GeneralDisarray in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-14-2011, 07:57 AM
  5. Adding a third match to an Index Match Formula
    By Weasel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2009, 01: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