Countif Function
 

=COUNTIF(H3:H26,""&B3)-COUNTIF(H3:H26,"="& B4)

Finds all the entries B3 and <B4 by
count the number B3
count the number = B4

Subtract the # =B4 from the # B3

Note: if you wanted the # =B3 and <=B4

=COUNTIF(H3:H26,"="&B3)-COUNTIF(H3:H26,""& B4)

Dan E

"ChrisG" wrote in message
...
I am attempting to use Countif function, e.g.

=COUNTIF(H3:H26,B3)

however I wish to construct a conditional argument
something like this:

=COUNTIF(H3:H26,"B3 AND <B4")

Having terribel time with syntax or just not doable.
Please help.

Thanks Chris