Fill formulas with row changing not column numbers
Posted on 2013-05-24
I have a formula that needs to be filled down. I want the cell letter to increment and not the number. I guess I want the row to increase while the column stays static.
Original formula: =SUM(C4, C12, C20)
I want to fill down for several rows: =SUM(D4, D12, D20), =SUM(E4,E12,E20), ETC...