Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif followup
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif followup
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif followup
"Rowan Drummond" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif followup
You're welcome. Not sure about a "programming indirection", I would
probably have referred to it as a concatenation. Lee Harris wrote: "Rowan Drummond" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF help | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |