=countif(A1:A5,B1)

"Doug Laidlaw" wrote:

As an example I have numerical data in cells A1:A5 (12,0,1,7,2). In cell B1 I
have the number 3. Now in cell A6 I want to count the number of cells that
are greater than 3. The answer should be 2. The countif formula lets me put
=countif(A1:A5,3) but I want to have linked it cell B1 so I can change
the parameter. I am trying to do this with the Indirect function but I can
not figure it out. Thanks!