I would like to count TRUE, if suppose I have Pass/Fail(Has a list) entries in other sheet. I tried to use, but I was not successful. Can someone to put some light on the same?
=COUNTIF(‘Administration’:E3:E100,‘Pass’)
The above function I am using to retrieve “Pass values” from Administration sheet from E3 to E100 rows
Sudhir