How do I stop Excel from progressing a formula in fill down or rig

M

mbaysden

I am trying to use a sumif command and want excel to copy the formula in each
cell EXACTALY like it is. Excel keeps "progressing" the formula. I just want
the exact formula repeated over and over.
 
D

Dave F

Use absolute references, not relative references. I.e, =SUM($A$1:$A$1000),
not =SUM(A1:A1000)

Dave
 
Top