I have a list of data ranging from A8:A107. I also have a graph (XY scatter) plotting the points. Within the XY scatter I have a Line going across the top from (0,110) to (110,110).....I have that line referenced to a spinner that moves the line up and down my graph when I click on it (depending on which direction I want the number to go (up, or down in value)) The value the line is currently at is listed in cell G5. What I need to do is the following : I want to Countif the numbers in the range of A8:A107 is greater than the current number in cell G5 (which changes when I click the up or down arrow on the spinner). I thought that a simple Countif(A8:A107,">G5") would be sufficient, but apparently not. Please help....
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Count If
- Thread starter njones
- Start date
Similar threads
- Question
