Replace formula in C12 (W&B) sheet with this formula:
=IF(HLOOKUP('Flt Plan'!$Q$31,Aircraft!$B$2:$Y$62,24,FALSE)="Y", SUM(C5:C11), SUM(C5:C11)-C8)