Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use "count if" with criteria within a cell?
How do I use the count if function with the criteria being or < (greater
than or less than) within defined cell that has a single numerical value? Count if with or < when it has a typed in number works fine. I cant seem to get it to work when I specify a particular cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use "count if" with criteria within a cell?
=COUNTIF(A:A,"10")-COUNTIF(A:A,"20")
will count all items between and including 11-20 -- __________________________________ HTH Bob "Kim SACS" <Kim wrote in message ... How do I use the count if function with the criteria being or < (greater than or less than) within defined cell that has a single numerical value? Count if with or < when it has a typed in number works fine. I cant seem to get it to work when I specify a particular cell. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use "count if" with criteria within a cell?
Maybe...
=countif(a1:a10,""&B1) Kim SACS wrote: How do I use the count if function with the criteria being or < (greater than or less than) within defined cell that has a single numerical value? Count if with or < when it has a typed in number works fine. I cant seem to get it to work when I specify a particular cell. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show "yes" or "No" in a cell if certain criteria is met? | New Users to Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Count occurences from one worksheet to another with "IF" Criteria | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |