Excel - 'adding' rows to a cell reference to indicate a range from the starting cell reference to a final cell reference that can vary.

Question

On an excel spreadsheet, I want to add a certain number of rows to a cell reference so that I can specify a range based on the number of rows used. E.g. I want to add 47 rows so that C10 becomes C57. So, starting with cell reference C10, is there a way to do this so that the range covered (to sum values in a column between this range for instance) is between C10 and a specified number of rows later, in this case C10:C57. Alternatively, in a worksheet, how do you stop calculations when they reach nil (e.g. on a credit loan repayment where deductions are made each month until a nil value is reached) so that the last cell reference is the last cell with a non-zero value and then how do I tell excel to read that particular cell?

Answer 1

Hello,

there are several approaches for the first part of your question, for example

=sum(c10:offset(C10,47,0))

=sum(offset(C10,0,0,47+1,1))

For the second part of your question, you can use an IF function to check if a certain value is reached and then return something. An example of your data structure would help. You may want to put that into a new question.