I would like to count the occurances IF a certain condition is met.

Specifically, there are small, medium and large companies and I want to be
able to count the number of "Yes" responses to a question (say Q1), but only
for the Small companies, then only for the Medium, then only for the large.

Size Q1
Small Yes
Med Yes
Large No

I have tried different versions of Countif and IF but can't get it right.
Seems like it should be simple but it's got me stumped!

Using Excel 2000 on XP. Tia!

cheers,
klam