# How to 'drag-copy' a formula to the same row and modify (only) the column parameter? [closed]

Hi,

I have formula in C column =SUM(INDIRECT("Mapa.C5"):(INDIRECT("Mapa.C7"))) and i would like to drag and copy same formula to other columns only change "C" to "D" like D column to have formula =SUM(INDIRECT("Mapa.D5"):(INDIRECT("Mapa.D7"))) drag and copy dont work.

Best regards