EDIT: Thanks to Erik's help It works flawlessly. I made a new approach to this and works as well. I'm going to link the sheet so others can learn and use it for their own use. https://docs.google.com/spreadsheets/d/1snPK6wBmR0Xbz4PFLO8sG_hBSHOpND-e_UGxL033VtE/edit?usp=sharing
What I'm having trouble is grabbing all values in certain column and row all the way down to end of a certain column and row. I set up a drop-down list that I'm working with to incorporate with my tables.
Below is how sheet 1 looks like. Drop-down list is setup from range using data validation from sheet2
|Drop-Down List1||Drop-Down List2|
|This will show the sum of drop-down list 1 and drop-down list 2||This will show the sum of drop-down list 1 and drop-down list 2|
I have two drop-down list that has value assigned in it which is referred to an array on another sheet.
Below is sheet 2 that has my data stored for sheet 1
This is very similar to what I have set up. So to explain what I want. What I want is to grab ALL data in each cell in a column between and with drop-down list 1 and drop-down list 2 value. For example under drop-down list 1, I select name2 and for drop-down list 2 I select name4. On sheet 1, Under GOLD header I want the sum of gold that get all data from name2 through name4, Which comes out to 60. 33 + 21 + 6. Should look something similar to this
Example 1: The top of this is drop down list value
Example 2: The top of this is drop down list value
What would be the best way to achieve this?