Excel IF(Countif =7-cell)

im trying to to fin how many closed toll gates in a project is on time in full based on how many closed there are.

So cell a1,b1,c1,d1,e1,f1,g1 contains string ON TIME if a tollgates i on time. ( blank if its not closed and delay if not on time)

I then have formula in H1 =COUNTBLANK(project_master_data[@[Work Order]:[Total Actual]]) to count blanks (not closed tollgates)

An then I have in I1 =IF(COUNTIF(project_master_data[@[Pre-study scheduled start]:[Implement Actual]];"on time")=7;"Yes";"No") to count how many "on time" there are (on full should be 7) but i want it to be dynamic to the number of closed tollgates.

So i tried =IF(COUNTIF(project_master_data[@[Pre-study scheduled start]:[Implement Actual]];"on time")=7-h1;"Yes";"No") but i doesnt work.

Any suggestions?