extending a sum formula

edited 12/09/19 in Smartsheet Basics


I have to update a lot of sheets so that they will be ready for 2020, and i need to write a lot of sums formula, because if i expand them normally, the first one is SUM([revenue]13:[revenue]16) then the second one becomes SUM([revenue]14:[revenue]17) then SUM([revenue]15:[revenue]18) etc. But i dont want the same cells to be used everytime, id like for it to go SUM([revenue]17:[revenue]20) SUM([revenue]21:[revenue]24) etc.

The perfect thing for me would be to be able to select a number of cell and copy all the formulas at once and them paste that to the next sheet,

or else if there is another way to fill the formula that would provide a different outcome ?