Forum Discussion
Excel Formulas: SumIf, Index and Match
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? Index('Raw Data'!A2:A20000,MATCH('On Hand Inventory'!B10&F4,'Raw ...
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.