countif

D

drpence

I am trying to count the number of cells in a range that are less than a givin number. It works if I use a whole nunber but I want it to reflect a cell that would change.
 
D

Don Guillett

try
=COUNTIF(I1:I20,"<"&L1)

--
Don Guillett
SalesAid Software
[email protected]
drpence said:
I am trying to count the number of cells in a range that are less than a
Click to expand...
givin number. It works if I use a whole nunber but I want it to reflect a
cell that would change.
 
J

Jason Morin

=COUNTIF(myrng,"<"&F1)

HTH
Jason
Atlanta, GA
-----Original Message-----
I am trying to count the number of cells in a range that
Click to expand...
are less than a givin number. It works if I use a whole
nunber but I want it to reflect a cell that would change.
 
D

drpence

That's it. I Have been trying every combination possible with no luck.

Thank You
 
Top