Countif, Index, Match Indirect

    Can someone please help me below formula where I make mistake?


    1. cell H30, I want to count from multiple sheet.
    2. SheetName = All the sheet name.




    =COUNTIF(INDEX(INDIRECT(""&SheetName&"'!$C$5:$AM$17),MATCH(B32,"'"&SheetName&"'!$C$5:$C$17,0),0),H30)




    Thank you

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login