Sure. It's called Countif. See this article:
http://www.officearticles.com/excel/...ft_excel.h tm
************
Anne Troy
www.OfficeArticles.com


"barklek" wrote in message
...
I have 5 departments and I am trying to count the number of yes votes for
each dept, is this possible