COUNTIF with cell reference in a conditional criteria

[chrgrose]

I am trying to count the number of values in a table which satisfy a greater than/less than condition which looks like this:

=COUNTIF($C$418:$L$2801,"<-2000")-COUNTIF($C$418:$L$2801,"<-2025")

My problem is that the values 2000 and 2025 are part of a column which increases by this increment a few hundred times. So what I would WANT to work is something like:

=COUNTIF($C$418:$L$2801,"<-$B1")-COUNTIF($C$418:$L$2801,"<-$B2")

so that I could just drag this cell down and the relative row reference would be understood.

Is there a trick that could be done to write this?

 

[VoG]

Try

=COUNTIF($C$418:$L$2801,"<"&-$B1)-COUNTIF($C$418:$L$2801,"<"&-$B2)

 

[chrgrose]

Try

=COUNTIF($C$418:$L$2801,"<"&-$B1)-COUNTIF($C$418:$L$2801,"<"&-$B2)

VoG, you helped me with a problem a few days ago and here you've done it again. Bravo, good sir!