Can we use countif to count how many are greater than (rather than equal to) a constant?

Dear Excel Gurus,

Somewhere in my Excel file I named a cell and put a numerifc value in it. Let's say cell A2 is named "threshold" and has a value 5 in it.

Now I want to write a formula somewhere else where I will count how many cells in a range (let's say B1:B10) are above the threshold.

If I wanted to know how many cells in the range are equal to the threshold, that would be easy: =countif(b1:b10, threshold)
But I want something like =countif(b1:b10, > threshold).

IS there a way to do this with countif or some other function?

Many thanks.

Studiosa.

Yes, like this:

=COUNTIF(B1:B10,">"&threshold)

Hope this helps.

Pete

Pete_UK,
Thank you. Works like a charm :-)