countif function with compare
In a spreadsheet I would like to count the numbers of occurences that values in an area are greater or equal than a compare value. Both the area and the compare value are referenced. Example:
The area is B3:K3
The compare value is in cell A2
In Cell A1 I would like to display the number of occurences, so I'd expect to use a formula like this in cell A1:
=countif(B3:K3;??>=A2)
Doesn't work as countif compares only values or expressions. Is there any workaround?