Download Files:

Start File and Finished File:

https://excelisfun.net/files/EMT1348.xlsx

See how to look up multiple items, retrieve the number associated with the items and add the array of numbers. Examples of SUM Many VLOOKUPs:
1. (00:10) Introduction
2. (01:00) Exact Math Lookup for Adding Multiple Costs or Revenues using SUMIFS a& SUMPRODUCT functions.
3. (04:59) Approximate Match Lookup for retrieving multiple prices, which in turn must be multiplied by Number of Items to get Total Revenue, using the LOOKUP and SUMPRODUCT function.
4. (08:47) Exact Math Lookup for Adding Multiple Contractual Costs using SUMIFS a& SUMPRODUCT functions.
5. (10:42) Exact Math Lookup for Adding Multiple Contractual Costs using DSUM function.
6. (12:40) Summary
Question comes from Simona Stamatova at YouTube.
Related Videos:
Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF
https://www.youtube.com/watch?v=s_StqXi7yrA
Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT?
https://www.youtube.com/watch?v=gH2RMd9XQpU