Count of unique text criteria in multiple columns

[DAVEWRITER007]

Need help with a formula that can provide the count of students that have D or F in all 3 semesters;

Not getting the expected result with: {=COUNT(IF((sem1range={"D","F"})*(sem2range={"D","F"})*(sem3range={"D","F"}),studentIDrange))}

Student ID Semester1 Semester2 Semester3
77696 B B B
90791 D D F
30405 D C D
88256 A F A
9139 D F F
65012 A B A
6053 D D D
51784 A A B
41877 D D D
90685 D C D
97593 D F F
4442 D D D
45439 C B C
32511 D F D
90788 D D D
77558 B B B

[CK76]

May be...
=SUMPRODUCT(((sem1range="D")+(sem1range="F"))*((sem2range="D")+(sem2range="F"))*((sem3range="D")+(sem3range="F")))

[PietBom]

These formulas will do the sum:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.