I'm trying to use Countif using indirect function.

here is the

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:

CodePudding user response：

You can use the following formula utilizing