CODEWITHSUNDEEP
google-sheets
Tony
Tony

Reputation: 115

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"

enter image description here

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:

enter image description here

Upvotes: 1

Views: 1309

Answers (1)

marikamitsos
marikamitsos

Reputation: 10573

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"),"<>")

enter image description here

Upvotes: 1

Related Questions