SUM(...)
How to sum values returned by vlookup from the given range.
Used Functions
Category: Math and trigonometry
Adds its arguments
Syntax
SUM(number1,[number2],...)
Practice SUM Formula at Sheetzoom
SUM formula at Microsoft helpCategory: Lookup and reference
Returns a reference offset from a given reference
Syntax
OFFSET(reference, rows, cols, [height], [width])
Category: Lookup and reference
Looks up values in a reference or array
Syntax
MATCH(lookup_value, lookup_array, [match_type])
0
The formula relies on OFFSET() function because multiple values can not be returned by VLOOKUP or more accurately, VLOOKUP is unable to return range object. The thus returned values from the range is summed by SUM() formula.