CountIF or SumIf or SubtotalIf - array question

Hello Excel Geniuses,   I'm working on an insane spreadsheet that I 'got hold' of, trying to do some extractions on desperate sets within it.   Anyway, the problem today is related to this set: 3...