To sum the values returned by OFFSET, we use the SUM function.
To calculate the right starting point, we use theROW function.
Because the formula sits in cell F4, ROW() will return 4.
We use this fact to create the logic we need.
Then, we multiply the result by 5.
We provideheightas 5 because we want a range that contains 5 rows.
Finally, we providewidthas 1, because we want a range that contains 1 column.
This is done with theSUM function.
The SUM function sums the ranges returned by OFFSET.
These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
SUM can handle up to 255 individual arguments.
OFFSET is handy in formulas that require a dynamic range.
