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.

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.

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