Need formula to count table range depending on conditions in selected table columns

No, that's correct, so try this instead:

=SUMPRODUCT((INDIRECT(A2&"[Style]")=B3)*((INDIRECT(A2&"[[1]:[13]]")<>"")*((INDIRECT(A2&"[[1]:[13]]")<>"MISS")*((LEFT(INDIRECT(A2&"[[1]:[13]]"),2)<>"SP")))))