Value Lookup and Sum

[arandhawa23]

I have created a defined Range called Settings. In settings there's various items to select such as fuel, repair, etc. In the next column I have cost. For the data entry, the idea is to select from Settings and then mark the Cost in the next column. My goal is to calculate all the values that are marked as a certain setting. For example, if Fuel was marked in 2 rows and the cost in the next column was $200 for the first and $300 for the second, I want excel to sum these values to $700.

Anyway to do this? Sorry, am a starter to excel. Thank you!

 

[sijpie]

Have a look at this

Excel SUMPRODUCT formula - Syntax, Usage, Examples and Tutorial | Chandoo.org - Learn Microsoft Excel Online