countif with formula results

[msampson]

I'm trying to countif any number in a column 10,000 rows deep is greater than, say 120. But, the 120 is generated by a formula, AND, the numbers are randomly generated. This means that the numbers in the columns are actually formulas. I can see numbers greater than 120 but my countif returns zero. What do I need to do to make it interpret the result of the formula without pasting the actual values since I want to keep the form dynamic?
Thinking about it, I do actually want to know how many total are above the cutoff so maybe something is better than a single countif at the top of the column.

 

[D3allamerican07]

msampson,

This should be relatively easy based on my interpretation. Would you mind posting the formula of how the '120' is calculated.

Thanks,

Bill

 

[msampson]

msampson,

This should be relatively easy based on my interpretation. Would you mind posting the formula of how the '120' is calculated.

Thanks,

Bill

There are a bunch of formulas cascading one to another but the one in this column is

=IF($A9<=$F$2,IF($E9<0,"",IF(I9<$D$4,$D$4,IF(I9>$E$4,$E$4,I9))),"")

I'm creating a histogram and I need to count how many values are above a cutoff value. For purposes of this example it's 120 but I'll be changing error amounts and generating different cutoff values. So that formula I just posted is checking to be sure the value isn't above or below the max or min of the expected range. The original data is a set of random numbers constrained into a normal distribution with a given mean and standard deviation.
So, I don't want to sum the values, just count the number greater than the cutoff.

 

[msampson]

I figured it out.

I put the formula generating the cutoff into G2 and in the cell at the top of the column I want to count I have this syntax: =COUNTIF(J9:J10008,">"&$G$2)

The combination of the quotes and the ampersand makes it work.

 

[D3allamerican07]

Exactly what I was going to add. Glad you were able to make it work!