I would have expected something like that to work too, but it doesn't for
me.
Instead, try:

=SUMPRODUCT(--(A1:A5B1))

HTH,
Paul

--

"Sean Timmons" wrote in message
...
=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!