I am filtering on criteria in column C. The counts are coming from
column I.

I cut and pasted your formula below, but it's not working - the result
is #NAME?



If somehow you are filtering another column and you want count the Y you can use this technique

=SUMPRODUCT(--($I$2:$I$200="Y"),--(SUBTOTAL(3,OFFSET($I$2,ROW($I$2:$I$200)-*MIN(ROW($I$2:$I$200)),,))))


I have several custom views set to view various filtered populations of this group of people (different affiliations - in column C if it matters).