Copy/Paste formulas

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

Guest

How do I keep certain cells (those I want to point to a specific 'constant')
from incrementing while the remaing cells in my formulas increment as
expected. Example: ((E65)*(COUNTIF(I7:I7,"V"))) where the cell "E65" contains
a set value that I want to be placed in the result as I step down the
incremental (I) rows when the character "V" is found in the particular (I)
row. When I do my copy and paste, the (E) row increments as the (I) rows
increment.
 
You need to put the dollar sign ($) in front of the row and column reference
you wish to make an absolute reference.i.e. $E$65. This will not be
incremented when you copy and paste.

Jock W
 
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

Copying a formula down a summary sheet 4
This One Is Tricky Need Help !!!!! 1
Formulas won't increment when dragging to adjacent cells? 3
Automatically Increment numerically ordered rows 3
Auto Fill formula when inserting a new line 4
Incrementing values 2
how to paste formula but reference a fixed cell 3
Array VLOOKUP lookup_Value does not increment 3

Back
Top