darkyam,

I figured it out. Sorry I wasn't very clear. My solution was to plug in this formula:
=(COUNTIF(K11:K58,"Complete"))/COUNTA($D$11:$D$58)-COUNTIF($D$11:$D$58,"N/A")

Thanks for the reply!
DW