I have a set of numbers from rows 1 to 5 in column A. Let's say the set is:
1
2
3
4
5
=SUM(A1:A5) equals to 15
I'd like to create a SUM formula for the values in those rows dependent on the value of a scroll bar or a spin button, e.g. if the value of the scroll bar (or a spin button - I don't know which one would work in this case) is 1, the SUM would be from row 1 to 5 (ie 15). If the value of the scroll bar is 3, the SUM should be from 3 to 5 (ie 12).
How do I link the value from the scroll bar / spin button to the SUM formula?
Thanks.