Sum from column number

OFFSET formula gives us reference to a range, from a given starting point with given number of rows to be considered and number of columns to be considered.

OFFSET formula looks like this:

=OFFSET (starting point, rows to move for starting point, columns to move for starting point, number of rows to be considered, number of columns to be considered)

To get total of number of row and/or number of columns use the formula

= Sum (Offset (SP, RSP, CSP, NOF, NOC))

Tip- In case dealing with years please -1 from the year variable to get exact results.