Formula examples that demonstrate how to use Excel VLOOKUP and SUM or SUMIF functions to look up and sum values with one or several criteria. You can use these formulas on any data in any version of Excel 2013, 2010, 2007 or 2003.

See the complete tutorial here: Excel VLOOKUP with SUM or SUMIF function – formula examples