Need count against specific category text,

[faraz502]

Need count against specific category text,




Exp:



In sheet1

Cell A2: Cleared Before Intervention



And in sheet2
Cleared before Intervention in different cells and columns


Range is A2 to Z3656


So I need count in sheet1 on cell B2

 

[Ron Coderre]

Have you tried something like this:

B2: =COUNTIF(Sheet2!A2:Z3656,Sheet1!A2)

 

[faraz502]

Have you tried something like this:

B2: =COUNTIF(Sheet2!A2:Z3656,Sheet1!A2)

Dear Thank you very much