Blog Archives

Use SUMIF on a column defined by MATCH

This is a good alternative for the INDEX function combined with MATCH, when your data source consists of non unique values, and you need a sum instead of a specific value. As the SUMIF does not work with column numbers

Posted in Excel Formulas Tagged with: , , , , , , ,

Ultimate Index: combine (nest) INDEX and MATCH..

1. INDEX formula: =INDEX(RANGE,ROWnumber,COLUMNnumber) So in the example above, to be able see the price for 20 apples, you use: =INDEX(B2:D4,1,2) ==> Result is $2 2. MATCH formula: =MATCH(LOOKUPValue,LOOKUPArray,MATCHType) So in the example above, to know the column for Apple,

Posted in Excel Formulas Tagged with: , , , , ,