Excel Magic Trick 366: Lookup Adding For Accounting Estimate
Online Courses for microsoft excel :
Course updated 2009-08-13 20:59:13
Instructor : ExcelIsFun
Course Duration : 3:15
Rating : 4.77 / 5
Step by step & Descreption :
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.