Need addtional criteria to count where "Actual" dates earlier that "Scheduled" DATE

As shown on the attached SUMMARY sheet, Product is in A2, Order Date in B1.

Following formula works perfectly in counting how many records in Col A of Schedule sheet match the product in A2, and were ordered in the month in B1:

=COUNTIFS(Product,$A2,Ordered,">="&B$1,Ordered,"<="&EOMONTH(B$1,0))

What's the extra element that will find how many of those ALSO have a "Received" date (Col D of the Schedule) earlier than the Scheduled date (Col C of the Schedule), given that both dates vary from row to row?

All suggestions, solutions and pointers welcome as ever

Ochimus

Try this in B4 and copied right:

Formula:

Please Login or Register  to view this content.

BSB

Badly,

Many thanks for prompt solution.

Can now close this as solved.

Ochimus