function - Cell contains some words but not others

Question

I am trying to see if a student received all A's (A+, A, A-), which would make the statement true and if they received even one grade other that an a then it would be false. This is the function I've tried, but it always comes back with false.

=AND(COUNT(SEARCH(C35:C37,D9:D16))>0,COUNT(SEARCH(D35:D45,D9:D16))=0)

question from:https://stackoverflow.com/questions/65926372/cell-contains-some-words-but-not-others

Answer 1

try:

=INDEX(SUM(IF(REGEXMATCH(FILTER($C$3:$F$10, $C$2:$F$2=$A17), "A"), 1, ))=
 COUNTA(FILTER($C$3:$F$10, $C$2:$F$2=$A17)))