Countif using Indirect

I’m trying to use Countif using indirect function.

here is the trix

I’ve cells which has direct referring like Alphabet & Major. I’m trying to get count which are not Alphabet & Major and get the value in "other"

I’m using

=if(B$1="","",COUNTIF(INDIRECT(B$1&"!$A:$A"),$A4))

to get the value of others. Not sure I’m doing right. Any inputs on this.

Desired Output:

>Solution :

You can use the following formula utilizing COUNTIFS instead and pull to the right

=COUNTIFS(INDIRECT(B$1&"!$A:$A"),"<>"&$A2, 
          INDIRECT(B$1&"!$A:$A"),"<>"&$A3,
          INDIRECT(B$1&"!$A:$A"),"<>")