Multi-conditional count



Hello and thank you for reading.

I'm trying to get a multi-conditional count of items from my table of
data as follows:

Say a teacher has a class of students that are going to go on a field
trip to the theme park and to do so the student has to have an "A"
they had to of paid and they have a note from their parent. This
unfortunately has to be done with text (I know).

I want to count the number of students who get to go on this field
trip. This should come to three students. I tried to use "countif" but
to no avail. Any suggestions or ideas are sincerely appreciated.

Grade Paid Note
A N Y
A Y N
A Y Y
A Y Y
B Y N
A N N
A Y Y
B Y Y
A N Y

.



Relevant Pages

  • Re: Pupil sex film teacher is banned
    ... A teacher at a Shropshire public school who filmed a student having ... sex in his room during a school trip has been banned from teaching. ... Former Shrewsbury School teacher Michael Clarkson, who is in his 30s, ... The committee found that Mr Clarkson had allowed students to consume ...
    (uk.legal)
  • Re: Pupil sex film teacher is banned
    ... sex in his room during a school trip has been banned from teaching. ... Former Shrewsbury School teacher Michael Clarkson, who is in his 30s, ... The committee found that Mr Clarkson had allowed students to consume ...
    (uk.legal)
  • Pupil sex film teacher is banned
    ... A teacher at a Shropshire public school who filmed a student having ... sex in his room during a school trip has been banned from teaching. ... The committee found that Mr Clarkson had allowed students to consume ...
    (uk.legal)
  • OT: "Teachers" in TN
    ... these clowns don't have professional insurance coverage. ... Tennessee -- Staff members of an elementary school ... and lasted five minutes during the weeklong trip to a state park, ... But parents of the sixth-grade students were outraged. ...
    (alt.sports.baseball.ny-yankees)
  • NYC students in hot water after trip to Cuba
    ... NEW YORK -- A spring break trip to Cuba taken by students and a teacher from a public high school in New York City has raised concerns about whether the group violated U.S. restrictions on travel to the Communist country and the possibility some could face thousands of dollars in fines. ...
    (soc.culture.cuba)

Loading