Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See Mr Excel and excelisfun use two methods to lookup a column of sales amounts in order to create a single cell formula that will add all the bonuses. Learn many tricks about the LOOKUP function, and also how to use SUM and SUMPRODUCT. Array Formulas.
@krn14242 , you are welcome!
ExcelIsFun 1 month ago
Thanks mike and bill, Mike had less keystrokes, maybe he should get the point.
krn14242 1 month ago
@0selam , I am glad that you like it!
ExcelIsFun 1 month ago
great!
0selam 1 month ago