The countif function in Numbers for Mac
The attached function does not work, is there a way to actually accomplish what I am trying to do. I want to know how many values in the specified region are greater than the value entered in a specific cell.
Question marked as
Best reply
Try
COUNTIF(E21:F24,">"&D21)
You don't want the D21 within the quotes because it is a cell reference. Putting it within the quotes makes Numbers think it is a string.
SG