Yes you can use a list, but to do that you will now need to wrap the Countifs in Sumproduct.

=SUMPRODUCT(COUNTIFS(Netcard!$C$4:$C$20,$F$1:$F$2, Netcard!$D$4:$D$20,"Kiosk Assembly"))

F1:F2 = Waiting Parts and Open

BTW: In the file you attached, you did not have the Countifs wrapped in Sum. It must be wrapped in order for the OR operation to take effect.