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<)