moving a formula

C

Crawford

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?
 
C

Camilo

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?
 
H

hnyb1

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.
 
Top