Dragging Cells with Equations

[supernova5271]

I have 20 rows of cells which contain a big formula.
Everything in the formula is constant except one variable.
That variable is read through alternate cells.
For example
frist cell contains = AVERAGE(A$6:$AT$102)
Second contains = AVERAGE(C$6:$AT$102)
Third contains = AVERAGE(E$6:$AT$102)

when I try to drag the cells the above three equations always contain the same first variable instead of it changing with each cell.
Can some one help ?

Thanks

[se1429]

Hi,

Relative cell refrences (without $ sign) works as follows:

When you drag the handle down, the letter of the cell reference (e.g A1) will remain the same but the number will change.
When you drag the handle to the right, the numer of the cell reference will remain the same but the letter will change.

So in your case the letters A, C and E will not change unless you drag left or right.

Regards.