countif followup

L

Lee Harris

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!
 
L

Lee Harris

Rowan Drummond said:
Try

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

Regards
Rowan
Click to expand...

oo, that's like a programming indirection - never seen that before, many
thanks!
 
R

Rowan Drummond

You're welcome. Not sure about a "programming indirection", I would
probably have referred to it as a concatenation.
 
Top