=COUNTIF(G10:G1009,">C9")

This formula is not returning the correct result. It returns 0. I want it to count the number of rows that contain a value, which is less than that in C9. Thanks.

Dan