Help with calculating for multiple vendors their delivery performance

[Abelardus]

Hello,

I have a spreadsheet with hundreds of vendors/suppliers. Each vendor delivers multiple parts for which some are delivered "Early", some "Late," and some "On-Time."

Some vendors deliver the same type of part, so vendors share the same part with their own delivery status.

I have calculated overall the percentage of each "delivery status" ("Early", "Late," and "On-Time") using COUNTIF (column with list of delivery status) divided into COUNTA (column with list of delivery status).
Since the delivery status is calculated from dates in other columns, it shows as formula within each cell under the Delivery Status column/field.

However, I need to calculate instead the percentage of the three delivery status per vendor (out of the total of all deliveries done by all vendors in each status). E.g., Vendor A delivered On-Time x% out of the total of On-Time deliveries done by all vendors.

Ultimately, I need to be able to identify the "Top 10" vendor that delivered "Early" and likewise the top under "Late" and so on "On-Time" based on the above calculations.

This is a perpetual spreadsheet that will be refresh constantly. Below is how the data is structured in the spreadsheet.

I do not know how to calculate the percentage of the three delivery status per vendor against the whole for each status.

Your helps is very appreciate it,

Abelardus

VENDOR	PART ID	DELIVERY STATUS
Vendor A	Part A	Late
	Part B	On-Time
	Part C	Late
	Part D	Early
Vendor B	Part A	On-Time
	Part E	Late
Vendor C	Part A	Late
	Part X	Early
	Part Y	Early
Vendor D	Part X	On-Time