I am trying to contruct a formula to count the number of numbers between say 10 and 20 in a large range of numbers in order to contruct a frequency distribution using COUNTIF.

If I use a number in the condition part of the COUNTIF formula (say <10), the formula works. If I use a cell reference (say <F28) it does not work. Can anyone help me.