moving a formula

[Guest]

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?

 

[Guest]

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?

 

[Guest]

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.

 

[Peter81]

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

Pet