Array line C4..AA4 contains 5 repeating blocks mixed data, letters and
numbers, blanks. (repeated some 400 lines)

Need to count numeric total of occurrences IF C4 = "H" AND D4 = "Y", H4 =
"H" AND I9 = "Y", etc
There's other combinations, but just the one answer solves all.
What's the exact syntax for COUNTIF(AND) (or, alternate Count function) when
dealing with text, please ? Tried Googling, and ref books - can't find
anything that works. All I want is a single numeric total of occurrences.
Help appreciated !