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.



barklek wrote:

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

--

Dave Peterson