How to count number of occurrences in a table if certain criteria are met.

[VBAhelp3456]

Hi there,

I am trying to write a formula to populate a table on sheet 2. Basically I need to count the number of deliveries, pickups or on holds for that meet certain criteria ie on June 12 product A had 1 old customer order & then picked up the product, therefore the cell would populate 1. I have complete data for June 12 as an example.

Thanks