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.
Bookmarks