Countif formula

[amwilber]

Hello,
I have been messing around with a countif formula for a while now, I can't get it to do what I want it to do, please help.


The formula I am using is below.

=COUNTIF(Page2!B2:B200,Page1!B1)

What I want to change is the changing of the first part of the formula when I drag the formula down into other lines. For example...

Line 1 I want this =COUNTIF(Page2!B2:B200,Page1!B1)
Line 2 I want this =COUNTIF(Page2!B2:B200,Page1!B2)
Line 3 I want this =COUNTIF(Page2!B2:B200,Page1!B3)

The way the formula is currently working it is changing it like this
=COUNTIF(Page2!B3:B201,Page1!B2) when I drag the formula down to another line.

Thank you in advance for the help!

 

[Matty]

Try:

=COUNTIF(Page2!B$2:B$200,Page1!B1)

Matty

 

[VoG]

Try

=COUNTIF(Page2!B$2:B$200,Page1!B1)

 

[amwilber]

Worked great! I knew I was missing something easy, will have to remember that for the next time. Thanks a lot for the help!