I have searched and found stuff close to what I was looking for, but not exactly what I was looking for.
http://office.microsoft.com/en-us/ex...010147120.aspx

This is what I have,
=COUNTIF(BD5:BD29,">"&D8)
This is what I want, but it doesn't work. I know I'm looking for some sort of an array, but I can't get the ctr + shift + enter to throw the brackets around it.

=COUNTIF(ABS(BD5:BD29),">"&D8)
Thanks in advance