|
Featured Tutorial
Featured Macro
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
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm