Calculating On Time Delivery

The array entered formula that yields the number of order numbers per customer is:

Formula:

Please Login or Register  to view this content.

Note that a unique list of customer names is created in column L by the array entered formula:

Formula:

Please Login or Register  to view this content.

The count of total orders is given by the formula:

Formula:

Please Login or Register  to view this content.

As you'll see two order numbers are assigned to both of the customers, this is confirmed in the first pivot table (highlighted in yellow).
The formula for the status report is:

Formula:

Please Login or Register  to view this content.

Note: that the numbers to not match because not all orders fall completely into one of the status categories, as confirmed in the second pivot table.
Note: entries in columns H and I were converted to dates using 'Text to Columns'
Note: *Array entered formulas are activated by pressing the Ctrl, Shift and Enter keys simultaneously while the cell is in the edit mode.
Let me know if you have any questions.

Since the orders belong to Big the following will need to be corrected:
1) There are 16 entries for order #235067, 10 of which are assigned to Ray.
2) There are 8 entries for order #235465, 3 of which are assigned to Ray.
When the data entry errors are corrected I believe that the orders by customer will equal total orders.
I have changed the formula for Status to:

Formula:

Please Login or Register  to view this content.

This does change the category numbers, however there are still orders where different entries have different statuses, such as #236280 where 3 entries are early and 3 entries are exceptions. To my way of thinking the logic for which status to assign to those cases will need to be worked out before a formula can be attempted.
Let us know if you have any questions.