K
koala
Can anyone advise me where i am going wrong
I am trying to use the following formula, but it does not give me
result. (cell is blank)
=COUNTIF(H63:H71,">G67")
If I change the ">G67" to the current value of G67 - ie .35584 it work
correctly.
The problem is that G67 is calculated from another area, and is alway
changing, so putting in its current value will be incorrect nex
calculation as that value will have altered. I dont want to have t
change this cell everytime to get it correct. I would prefer it to b
automatically correct.
Thanks in advance
Koal
I am trying to use the following formula, but it does not give me
result. (cell is blank)
=COUNTIF(H63:H71,">G67")
If I change the ">G67" to the current value of G67 - ie .35584 it work
correctly.
The problem is that G67 is calculated from another area, and is alway
changing, so putting in its current value will be incorrect nex
calculation as that value will have altered. I dont want to have t
change this cell everytime to get it correct. I would prefer it to b
automatically correct.
Thanks in advance
Koal