countif
 

how do i use the countif function
when i want the criteria to be a cell
i tryed this but it does not work
=COUNTIF(G6:G360,L23<)

countif
 

Try this

=COUNTIF(G6:G360,"<"&L23)

this will be less what is in L23 but not those equal to.

"ashw1984" wrote:

how do i use the countif function
when i want the criteria to be a cell
i tryed this but it does not work
=COUNTIF(G6:G360,L23<)

countif
 

how do i use the countif function
when i want the criteria to be a cell
i tryed this but it does not work
=COUNTIF(G6:G360,L23<)

if l23 just contains the value
=COUNTIF(C6:g360,"<"&l23)
if cell l23 contains for example <17 =COUNTIF(G6:G360,L23)

should suffice


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=503983