software

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,L23lt;)

Try this

=COUNTIF(G6:G360,quot;lt;quot;amp;L23)

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

quot;ashw1984quot; wrote:

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


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,L23lt;)

if l23 just contains the value
=COUNTIF(C6:g360,quot;lt;quot;amp;l23)
if cell l23 contains for example lt;17 =COUNTIF(G6:G360,L23)

should suffice--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=503983