Countif / Counta

I have a worksheet with company names, due dates, and mail dates. There is a column that produces a simple "Yes", "No", depending on whether or not the product shipped in the estimated time. From here I use a simple countif(range,"Yes")/Counta(range) to get the percentage of Yes and one for No.

One particular company is more important than the rest so I would like to do this based on the company's name. The company's are listed in column E.

I want to know "company A's" Yes, No stats???

I usually wind up with True / False answers

Any help is appreciated.

You can use Countifs and sumifs to allow you to set a tighter criteria based off of the company name.

=countifs(A1:A20,"Company Name",B1:B20,"yes") This will tell you all the Yes's for that specific company. Then you can divide it using the same formula for the no's.

Originally Posted by gak67

Assuming Company A doesn't appear on the list without a Yes or No, building on ScoGeosan's formula:

=COUNTIFS(A1:A20,"Company A",D1:D20,"Yes")/COUNTIF(A1:A20,"Company A") will give you the percentage

Yes, a pivot table would have worked but gak67 gave me what I was looking for.

Thank you all for your help!