I am looking for a formula adding values extracted from table. excel 2010

Hi there, i have been testing and trying many formulas but i can't seem to get the right one.

I am trying to make my excel look neat and at the same time make it simpler for myself to use.

I have a small table which i want to formulate as shown in the attachment.

I would like to be able to type a number in the given yellow boxes and have the result in the green box.

Example:

Yellow box 1 : 2
Yellow box 2 : 23
Green box : sum of all the prices of the boxes ranging from 2-23.

The problem here is that i do not want to add the level numbers together, i want to be able to type in the level number in the yellow boxes and it automatically extracts the price value and adds them all up in the green box.

You can use this like
=Sum("Click the first yellow cell in the row":"click the second yellow cell in the same row")

For example if you first yellow cell is C2 then type the below formula in Z2
=SUM(C2:Y2)

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

OK, I got it. I have use the following formula to get the desired result.

Please Login or Register  to view this content.

I hope it helps.

Glad to help you. Thanks for the feedback and adding reputation.
Please mark the thread as solved.