Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT317-323.xls
Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT317-323Finished.xls

See how to use the SUMPRODUCT & SUMIF functions together to Lookup multiple items and add them in one cell. This method is great when you have many things to add from a column of lookup results, but you dont want the lookup column to use up space in the spreadsheet. Lookup Sum. Lookup Adding.