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
=COUNTIF(‘Administration’.E3:E100;‘Pass’) - semicolon, not comma and dot after sheet name.
As B.Horvat expose, semicolon is needed as separator, but depends on you locale settings.
Also the text condition must go with double quotes, and single quotes on the sheet name is no needed if there are not spaces.
=COUNTIF(Administration.E3:E100;“Pass”)
Thanks for correction, single quotes in text condition I not saw and single quotes in sheet name I left, they don’t make error.
Thank you Guys!! It works!!