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.