Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT358-369.xls

See how to use SUMPRODUCT and SUMIF functions to lookup multiple values for expenses as a percent of sales, add them, then use the result to estimate what proportion of the estimate is allocated for that expense category. Lookup Sum. Lookup Adding.