You're profile says 2003, I *think* this will work in 2003. Take a look at the countif() function

If not, upload a saple workbook (no sensitive data) showing what you are working with, and what you want