In Microsoft Excel, changing the evaluated range on the fly requires a bit of work, but it's definitely possible thanks to the Offset() function.

How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

How to Count the Number of Non-Blank Cells in Excel. Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions.