Please help me to correct this formula
Column K: List of school names (XX-1, XX-2, XX-3, XX-4, XX-5)
Column L: List of school Levels (primary, secondary)
Column M: List of staff designations working in school XX
Find out the TOTAL number of “Principal” and “Vice Principal” working in ONE particular School
=countifs((K4:K30, “School name”, K4:K30, “school level”, K4:K30, “XX-1”), (M4:M30, “principal” or “vice principal”),