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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Use absolute references, not relative references. I.e, =SUM($A$1:$A$1000),
not =SUM(A1:A1000)

Dave
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locking a cell reference in a formula 1
Excel VBA 1
Excel How to get output of the formula instead of True or false 1
How do I do Conditonal Formatting with formula progression 4
using the =page! feature to transpose a row to column 0
Dmax formula 2
How to Control a formula by a character in adjacent column on same 4
Automatically Record Date in a cell 1

Back
Top