COUNTIF condition based on cell value

Hi there,

can anybody tell me how to get this working in a spreadsheet?

=COUNTIF(H2:H21,"<$B25")

B25 contains a number.

Thanks in advance.

=COUNTIF(H2:H21,"<"&$B25)

COUNTIF()

thanks so much! :slight_smile: