Hi,

Need some help

Currently trying to return a count from several different criteria. The worksheet is basically a tracker of parts, when they were ordered and when they arrived.

So for example

Date 1 = Inspection
Date 2 = Order date
Date 3 = Promise date

I will be tracking multiple orders so I'm after a formula that will count the orders if date 2 was raised before date 1 and arrived on or before date 3.

Been trying countifs but I keep coming back with 0 value