=Sumproduct((C1:C400 = "H")*(D1:D400= "Y")*(H1:H400 ="H")*(I1:I400 = "Y"))

Would be a guess at what you want.

Regards,
Tom Ogilvy

Len Dolby wrote in message
...
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 !