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.


See More: Vlookup sum

Report •

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:


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


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