Are you trying to drag across? The below would work if you dragged down.

Otherwise, you're trying to invert the data.

You can do that by entering =INDIRECT("$C"&COLUMN())+$F$8

"excelguy" wrote:

I want to copy a formula adding two cells together where one cell always
remains the same, i.e. - C8+$F$8 and then C9+$F$8 and so on until I have
reached C108. Whenever I drag the formula to the next cell the formula add
the next letter instead of the same letter , i.e. - instead of C10+$F$8, it
copies D10$F$8.
I also want to do the same type of formula for F8+$C$8 and it copies F9+$C$8
and so on all the way until F108+$C$8.
I need some help with this. Thanks