Thanks it worked!

"Harald Staff" wrote:

Hi Alexandra

Spreadsheet cells are close to useless when it comes to rejecting entries. A
testbox on a userform can do this.

Try
=Countif(range, "16F")+Countif(range,"16-F")

HTH. Best wishes Harald



"Alexandra" wrote in message
...
How can I restrict someone from typing a dash?
For example entry should be 16F not 16-F

Or how can I make my COUNTIF formula to count either entry with or without
dash?

Thanks, Alexandra