Excel Formulas: SumIf, Index and Match

Question

Hi,I made an Index Match Formula, and I need to add SumIf into it so sum duplicate matches together.Is there anyway to do it?&nbsp;Index('Raw Data'!A2:A20000,MATCH('On Hand Inventory'!B10&amp;F4,'Raw Data'!C2:C20000&amp;'Raw Data'!A2:A20000,0),MATCH(B3,'Raw Data'!A1:R1,0))*There might be some typos*&nbsp;Thanks.

riny_van_eekelen · Answer

nelly789&nbsp;Difficult to answer your question if we don't have an example of your file to play with.

kashibaba · Answer

You should use Sumifs first to shape your data then Index(match). index.match can be used inside Sumif(s) if you want to do it but it will complicate/slows down. Thanks.

patrick2788 · Answer

nelly789&nbsp;A sample would help.&nbsp; That's an unusual nesting you're proposing.&nbsp;&nbsp;

Forum Discussion

Excel Formulas: SumIf, Index and Match

3 Replies

Resources