Paste or fill non-consecutive integers

[micheldun]

I feel like this shouldn't be difficult, but I cannot figure out how to copy a few cells in a column and have their numbering format copy to several rows below in the same column. Example:

=SUM(D136:AB136)
=SUM(D138:AB138)
=SUM(D140:AB140)

I have a couple of hundred rows that need to be filled in this manner, but cannot find a way to not copy, paste and then go back and edit to fix all of the inevitable mistakes.

 

[Joe4]

You can use the INDIRECT along with the ROW/COLUMN functions to build your range dynamically to have it skip rows like that. But what we need to know is what cell addresses are you putting those three formulas in (as the formula is going to pull cell/row information from the cell that the formula actually resides in).

 

[micheldun]

In the first worksheet, it is starting in cell D62 and going to D134.

Thanks!