Using the COUNTA example change "Active" to "Completed"

=COUNTA(AB14:AB5033)-COUNTIF(AB14:AB5033,"Completed")


Using the SUM(COUNTIF example change "Completed" to "Active"

=SUM(COUNTIF(AB14:AB5033,{"Active","Cancelled","Suspended"}))