Calculate row totals of Yes/No

Hi,

I would like to know if it is possible to calculate row totals of Yes/No. I have two columns one with let's say a company number and one with Yes/No (Yes if they fulfilled a certain task and No if the haven't). I know how to count the Yes/No's -> =SUMPRODUCT(--(A7:A33="decoe");--(I7:I33="no"))

In this case the example is: company is decoe and value is no, it count's al the values of No for the company deco. A company can have more than one no (different rows) Instead of a company name I will use company numbers. What I would like to do is like when I use autofilter on the company numbers, have a subtotal of No for that company.

Is this possible? and how?