COUNTIF Example

NAME	POST
ARUSH	CLERK
AXAY	PEON
AJAY	PRINCIPAL
RAVI	TEACHER
KARAN	OTHER
NIRAV	CLERK
HARSHIT	TEACHER
SULAY	TEACHER
ANAND	PEON
MIHIR	PRINCIPAL
COUNT IF	3

Formula:-

=COUNTIF(B2:B11,"TEACHER")