+ Reply to Thread
Results 1 to 4 of 4

Sumif and Index Match

Hybrid View

  1. #1
    Registered User
    Join Date
    10-09-2011
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2003
    Posts
    19

    Sumif and Index Match

    Hi,

    Im trying to create a summary from a big data. I have tried with vlookup + sum if but since the value is before the lookup, it doest work.

    	A	B	D	
    	12	cost 1	type A	
    	3	cost 2	type D	
    	4	cost 3	type B	
    	55	cost 4	type D	
    	6	cost 5	type C	
    	7	cost 3	type D	
    	35	cost 2	type D	
    				
    				
    				
    Result				
    				
    	type A	type B	type C	type D
    Cost 1	12			
    Cost 2				38
    Cost 3		4		7
    Cost 4				55
    Cost 5			6
    How can archive this with sumif and index?

    Thanks in advance.
    Last edited by freqzz; 08-27-2014 at 03:33 AM. Reason: Solved

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Office 365
    Posts
    1,899

    Re: Sumif and Index Match

    Hi,

    Check this.

    Punnam
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-21-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003
    Posts
    93

    Re: Sumif and Index Match

    See the file attached.

    I dont think there is need of Index , only sumifs is giving the desired results.

    Kmahesh
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-09-2011
    Location
    Kuala Lumpur
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Sumif and Index Match

    HI,

    Works like a charm!

    i'll pin this as solved!

    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. Replies: 3
    Last Post: 05-08-2013, 02:10 PM
  2. [SOLVED] SUMIF with INDEX and MATCH?
    By mr_vic in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-22-2013, 11:35 AM
  3. Match index and Sumif
    By Katherine Venn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-21-2012, 02:31 PM
  4. Using INDEX, MATCH, and SUMIF together
    By Lea724 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-19-2011, 03:26 PM
  5. [SOLVED] Match& Index and Sumif
    By ciara_daniels@yahoo.com in forum Excel General
    Replies: 4
    Last Post: 08-21-2006, 11:10 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