How to use "count if" with criteria within a cell?

  • Thread starter Thread starter Kim SACS
  • Start date Start date
K

Kim SACS

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.
 
=COUNTIF(A:A,">10")-COUNTIF(A:A,">20")

will count all items between and including 11-20
 
Maybe...

=countif(a1:a10,">"&B1)



Kim said:
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.
Click to expand...
 
Back
Top