countif greater than cell value

[lost_in_the_sauce]

I know that I can do a =countif(A1:A50,">100"), and that will count all values in that array greater than 100, but I need it to point to a cell that has a value formula =AVERAGE(A1:A50) and I keep getting 0 as the count.

 

[Fluff]

How about

=countif(A1:A50,">"&B2)

where B2 is the cell with the number

 

[lost_in_the_sauce]

How about

=countif(A1:A50,">"&B2)

where B2 is the cell with the number

Thank you! I always forget about the "&"

 

[Fluff]

You're welcome & thanks for the feedback.