countif followup

[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]

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

[Lee Harris]

"Rowan Drummond" <rowanzsaNotThis@hotmail.com> wrote in message
news:OflPbHn6FHA.4076@tk2msftngp13.phx.gbl...
> Try
>
> =COUNTIF(A:A,"<"&B1)-COUNTIF(A:A,"<="&C1)
>
> Regards
> Rowan

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


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

[Rowan Drummond]

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

Lee Harris wrote:
> "Rowan Drummond" <rowanzsaNotThis@hotmail.com> wrote in message
> news:OflPbHn6FHA.4076@tk2msftngp13.phx.gbl...
>
>>Try
>>
>>=COUNTIF(A:A,"<"&B1)-COUNTIF(A:A,"<="&C1)
>>
>>Regards
>>Rowan
>
>
> oo, that's like a programming indirection - never seen that before, many
> thanks!
>
>
>
>>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!
>
>
>