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

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.

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

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"mbaysden" wrote:

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.

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

TY I knew it was a very easy solution. Thax again

"Dave F" wrote:

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"mbaysden" wrote:

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.