countif followup

  • Thread starter Thread starter Lee Harris
  • Start date Start date
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!
 
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!
 
You're welcome. Not sure about a "programming indirection", I would
probably have referred to it as a concatenation.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs with different restrictions 1
Countif(and 1
Countif not working 3
Excel function - countif 2
Countif statement using dates 15
count 3
COUNTIF with nestled IF? 2
Doing a countif against a substring of the range to be scanned 1

Back
Top