Articles

Solved Vlookup sum

February 28, 2009 at 00:36:27
Specs: Windows Vista

Can someone help me with a formula I am struggling with in Excel? I want to look up a code in a table and then sum a range of values to the right of the selected code. In essence I am struggling to combine a sum formula with a vlookup formula.

Thanks


See More: Vlookup sum

Report •


#1
February 28, 2009 at 12:02:23
✔ Best Answer

Let's say your codes are in A1:A4, the data to Sum is in columns B:D and your search criteria (the code) will be in E1.

Try this array formula:

=SUM(VLOOKUP(E1,A1:D4,{2,3,4},0))

entered using Ctrl-Shift-Enter to put the {} around the entire formula.

{=SUM(VLOOKUP(E1,A1:D4,{2,3,4},0))}

You can't just type the brackets to make it an array formula, you must use Ctrl-Shift-Enter each time you edit the formula.


Report •
Related Solutions


Ask Question