stop automatically changing fomula ...

  • Thread starter Thread starter caryn
  • Start date Start date
C

caryn

i have a countif function
COUNTIF(Locking!I16:I40,"f")
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")

How do I stop it from changing column I to J?!?!?!
thanks.
 
Take a look at Help's "The difference between relative and absolute
references" topic.
 
Put a $ before each I, making the columns absolute

=COUNTIF(Locking!$I16:$I40,"f")

If you enter this formula by pointing at cells, pressing the F4 key will
cycle you through absolute rows & columns, absolute rows & relative columns,
relative rows & absolute columns, and completely relative.

Check Help to find out about absolute & relative addresses
 
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

stop automatically changing formula! 2
combining formulas 1
Modify Formula 2
Modify a Formula 2
countifs Function not giving desired result with date criteria 2
Making COUNTIF update in real time 4
Finding the weighted average of text that have been given values 1
Excel Copy COUNTIF while retaining reference 7

Back
Top