I have a chart, and I have two other cells that change value. Based on the value of the 2 cells, it will determine which rows in the chart I add together - that value in another cell alltogether.
My chart is 15 rows in height. My 1st cell has value between 1 and 9. The second cell has a value between 1 and 6. What I need to do, is add the rows in the chart between the value of my 1st cell, and both cells added. (i.e. if the 1st cell is 3 and the 2nd cell is 5, I need to add rows 3 through 8 together on my chart)
Is there any way to do this?
My chart is 15 rows in height. My 1st cell has value between 1 and 9. The second cell has a value between 1 and 6. What I need to do, is add the rows in the chart between the value of my 1st cell, and both cells added. (i.e. if the 1st cell is 3 and the 2nd cell is 5, I need to add rows 3 through 8 together on my chart)
Is there any way to do this?