C
cerestes
I think there should be a simple solution to this.
I have a range of numbers (K2:AK2).
I need to count the number of cells in which the value is greater than
a value in cell F2. F2 Changes in each row, so I can't just use a
constant numerical value.
The formula i currently have is:
=COUNTIF(K2:AK2, ">F2")
This doesn't seem to work. Without the > symbol, it accepts F2 as a
variable cell. Once I add the > into the formula it seems to be
treating F2 as a numerical value.
Any suggestions?
I have a range of numbers (K2:AK2).
I need to count the number of cells in which the value is greater than
a value in cell F2. F2 Changes in each row, so I can't just use a
constant numerical value.
The formula i currently have is:
=COUNTIF(K2:AK2, ">F2")
This doesn't seem to work. Without the > symbol, it accepts F2 as a
variable cell. Once I add the > into the formula it seems to be
treating F2 as a numerical value.
Any suggestions?