CountIFs with SUBTOTAL

Hi Experts,

I found this formula for a Countif with SUBTOTAL courtesy of Biff:

SUMPRODUCT(SUBTOTAL(3,OFFSET(Q10:Q96,ROW(Q10:Q96)-ROW(Q10),0,1)),--(Q10:Q96="SL"))

How do I modify the formula if I'm counting multiple conditions? I'm currently using this:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(Q10:Q96,ROW(Q10:Q96)-ROW(Q10),0,1)),--(Q10:Q96="SL"))+SUMPRODUCT(SUBTOTAL(3,OFFSET(Q10:Q96,ROW(Q10:Q96)-ROW(Q10),0,1)),--(Q10:Q96="AWOL"))+SUMPRODUCT(SUBTOTAL(3,OFFSET(Q10:Q96,ROW(Q10:Q96)-ROW(Q10),0,1)),--(Q10:Q96="NCNS"))

Is there a better way of writing the formula?

Thank you,

Try this

=SUMPRODUCT(SUBTOTAL(3,OFFSET(Q10:Q96,ROW(Q10:Q96)-ROW(Q10),0,1)),--ISNUMBER(MATCH(Q10:Q96,{"SL","AWOL","NCNS"},0)))

works like a charm. Thank you so much!!!