"SELECT COUNT(*) FROM table WHERE numeric_column < 
  (SELECT numeric_column FROM table WHERE your_criteria)"
[download]

I believe you knew, but just to make it complete. The criteria has to make sure that only one row is returned from the subquery. Otherwise you would get error like 'too many rows returned'.