Try

=COUNTIF(A:A,"<"&B1)-COUNTIF(A:A,"<="&C1)

Regards
Rowan

Lee Harris wrote:
Sorry fellas,
forgot to ask - how can you extend the counting to have limits specified in
a cell,


i.e. this won't work, but I need to vary the limit paramaters and see the
results,
=COUNTIF(A:A,"<B1")-COUNTIF(A:A,"<=C1")


I knew I hadn't gone bonkers, got confused about what I was asking!