Do you use an English version of Excel?

If no, what language do you use?


wrote:

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).

--

Dave Peterson