Main Profile

At A Glance

Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution

See how to take transaction records with rows of numbers, math a single criteria, then lookup a row of commission rates and multiply all the rows from the transactional data set by the row of commission rates. Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Length: 07:18

Contact

Questions about Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution

Want more info about Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question