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.