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

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

If you make the formula $C8+$F$8 it will prevent the C from changing to the D.

Out of curiousity what exactly are you doing? Sounds like you are filling a
couple of rows and columns with the same formula?

Carrie

"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

The formula you gave didnt work not sure why.

Im trying to make a table where I can look up a value on the x and y column.
for example, if a student gets a 82 on exam#1 and a 78 on exam#2, his grade
will be something (two values I'm copying from two tables that multiply 1
through 100 by a certain percent). Basically, I want to make a chart so that
people will know what they need to get on the 2 exams to get a certain grade.



"Sninkle" wrote:

If you make the formula $C8+$F$8 it will prevent the C from changing to the D.

Out of curiousity what exactly are you doing? Sounds like you are filling a
couple of rows and columns with the same formula?

Carrie

"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