On 16 jun, 21:52, " wrote:
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

Use SUMPRODUCT((A1:A100="A")*(B1:B100="Y")*(C1:C100="Y "))
You will get the number you want