- Sep 25, 2005
I am using Excel 2013 and would like to have a Vlookup formula look up a certain values and return the sum of it and 6 cells directly beneath. Can this be done? For example, lets say I look up the date 01/01/14 in a table and based off my formula it returns the value 10 from cell b2. The 6 cells below (B3:B8) each contain the value 5, thus I would like it to return the sum of B2:B8 (40). So, basically lookup a value and return the sum of it and the 6 cells below. Hopefully this makes sense. Any help is much appreciated.