#### seagull over nz

##### New Member

- Joined
- Mar 26, 2013

- Messages
- 5

1 10

2 15

3 21

4 25

5 13

6 12

Now in my look up formula I would like to sum a range. For instance in the first cell I would like to sum the value of the range 3 to 5 with the answer as 59 (21+25+13). How do I create a vlookup formula that pulls in the values corresponding to a certain range? Does that make sense. At the moment I have a long string of vlookups for 3, 4 and 5 within the same cell formula but it becomes a bit tiresome.

Thanks in advance.