Posts by Kumar Chandra

    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