Sounds like you might need to look at using the COUNTIF function. See Excel help for details or post a copy of your workbook if you need further help.