Calculating the sum of a range

Hi there! Haven't posted in a while, I'm hoping for a little bit of assistance. I have a very simple Google sheet hopefully linked below.

Essentially, on the calculator tab I want to be able to select a from and to level cap, and have the gold cost of those calculated in cell D3. The Data tab contains a list of incremental level caps (collumn a) and the gold cost to upgrade to this level (collumn b)

So if I had a cap of 50 (data A2) and wanted to go to 125 (data A5) the total cost would be the sum of Data B2 to B5. (30).

Is it possible to have that calculation appear on the calculator tab based upon the drop downs I've created?

Contains no confidential data:
https://docs.google.com/spreadsheets/d/1_ZHltyo33ZjKoh0RtrE1NBdOExWSkscLr_A4zLbDSTo/edit?usp=drivesdk

Originally Posted by MrShorty

Have you considered a SUMIFS() function? https://support.google.com/docs/answ...50558230944-NA
Something like =SUMIFS(Data!B2:B200,Date!A2:A200,">="&B3,Data!A2:A200,"<="&C3)


Does that help?

Ha! I feel like a real doofus now. That is perfect. Thank you so much!