moving a formula
 

See my formula...
=COUNTIF(All!A2:A844, Feb06!A1)

When I copy my formula to the next cell I only want Feb06!A1 to increase to
A2, A3, and so on. But A2:A844 should remain. What should I do?

moving a formula
 

Use an absolute reference $(Column)$(Row):$(Column)$(Row);

Example:
=COUNTIF(All!$A$2:$A$844, Feb06!A1)
--
Hope this Helps!
Camilo

Objective: To help one person each day!

Feedback is greatly appreciated! Please let me know if I've answered your
question or if my post was helpful to you?


"Crawford" wrote:

See my formula...
=COUNTIF(All!A2:A844, Feb06!A1)

When I copy my formula to the next cell I only want Feb06!A1 to increase to
A2, A3, and so on. But A2:A844 should remain. What should I do?

moving a formula
 

Make them a fixed reference as follows:

=COUNTIF(All!$A$2:$A$844, Feb06!A1)

With cursor between the A2 click on F4, ditto for A844.

"Crawford" wrote:

See my formula...
=COUNTIF(All!A2:A844, Feb06!A1)

When I copy my formula to the next cell I only want Feb06!A1 to increase to
A2, A3, and so on. But A2:A844 should remain. What should I do?

moving a formula
 

=COUNTIF(All!$A$2:$A$844, Feb06!$A1)

Pete


--
Peter81
------------------------------------------------------------------------
Peter81's Profile: http://www.excelforum.com/member.php...o&userid=25353
View this thread: http://www.excelforum.com/showthread...hreadid=532662