in the absence of any additional information you could use a sumproduct for this, like this...
=SUMPRODUCT((J2:J6<=TODAY())*(F2:F6<>"complete")*(F2:F6<>"closed"))
this will count all items in J2 to J6 where they are less than or equal to today and not equal to either complete or closed in col F.
adjust from there.