Can you use Sum and Vlookup to sum up a range between two cells?

[ZeroChill]

I have tried =SUM(Vlookup:Vlookup) but it does not really work with that logic. So maybe has some idea how I could solve this.

I try to explain my problem.

I have a row called "level" and for each level there are costs ("stone") for that special level.
I wanted to write a =Sum function that lets me type in a level in a cell and then it sums up all the stone that is needed for that level. So as example. If I type in level 3 it should add up 10, 20 and 30.

Here is an example how my excel looks like:

Please Login or Register  to view this content.

Does anyone know how to do this?

I mean my emergency solution is to make another column and sum it up all so that I have "cost per level" and "cost total until level" but I wanted to try to solve it cleaner.

This is the formula that I tried, but it only returns the sum of the 2 vlook up values, not everything inbetween

=SUM(VLOOKUP(0;Metal!$B$25:$P$83;13;TRUE);VLOOKUP($B$1;Metal!$B$25:$P$83;13;TRUE))

I basically want to sum up a range which constantly changes based on the level that I want to look up.

[6StringJazzer]

A hint for good titles/questions: Don't start out with the solution, start out with the problem. VLOOKUP is barking up the wrong tree for this problem. VLOOKUP only returns a single value. INDEX returns the actual range, which is what you want.

Also, please give us some clue to your location in your profile so we know what localization to apply. Your formula looks like a non-U.S. syntax, which is different from how formulas look to me.

Please Login or Register  to view this content.

Where V1 is value for the first level and V2 is the value for the second level.

[FlameRetired]

Or perhaps if you type in a value in D1 use this in D2

Please Login or Register  to view this content.