Since you have some hidden rows, you might have auto filter turned on.

If you use auto filter and query on <2000 in Column CF
place this formula in cell CF1002:

=subtotal(102,CF3:CF1000)

the 102 counts and ignores hidden values

HTH
--
Data Hog


"Doug" wrote:

=COUNTIF($CF3:$CF1000,"<2000")

How can I get this to return the total count excluding the hidden cells in
the range?
Right now it shows all.
--
Thank you!