Main Profile

At A Glance

Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)

See how to lookup and then add values with three criteria using 2 methods: 1. Add helper column that joins two criteria, SUMIF function, Ampersand to join criteria, INDEX and MATCH function to retrieve entire column of values (3rd criteria). 2. SUMPRODUCT and joining columns and matching joined criteria and , INDEX and MATCH function to retrieve entire column of values. Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Length: 08:12

Contact

Questions about Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)

Want more info about Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question