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?