3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602

Download Excel File (to follow along with video): https://ift.tt/306B9CN
Learn about how to use three lookup values to lookup values and then add. The trick is that two of the lookup values are in the records and one is in the Column Headers. See how to lookup a column with XLOOKUP or INDEX and MATCH functions, then but the resultant range object into the SUMIFS Function.

View on YouTube