using the count function

[barklek]

I have 5 departments and I am trying to count the number of yes votes for
each dept, is this possible

 

[Anne Troy]

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

 

[Paul Sheppard]

I have 5 departments and I am trying to count the number of yes votes
for
each dept, is this possible

Hi barklek

You could do this with a Pivot Table, Data > Pivot Table

 

[Dave Peterson]

I like the pivot table option, too.

But you could use a bunch of formulas like:
=sumproduct(--(a2:a99="dept#1"),--(b2:b99="yes"))

Or you could use another column:
=if(b2="yes",1,0)
and drag down

Then sort your data by department and use data|subtotals.