Forum Discussion
Excel with variable cell selection
Hello, I have a list of numbers, and I want to make a formula to choose how much of that list is needed. For example, I want to choose A1 to A5, but the number 5 is from an other calculation. So...
It could be
=SUM(OFFSET($A$1,0,0,5))
where instead of 5 you may use reference on result of your calculations