Tricky Count of Unhidden Rows

[jim may]

Below is My Col2 of a 8 column auto-filter table; I Auto filter ONLY on Col 8
at ant time, But I need a formula for Cell d4 that will give me at any point
the Count of the "SI" count in my Col 2. Can someone assist me? TIA,
Jim

Col B (2)
WhosePrc (my header row7)
SI my first data record - row 8)
SI Average

zCP
zCP Average

SI
SI Average

zCP
zCP Average

SI
SI Average

zCP


zCP Average

SI
SI Average

zCP
zCP Average

 

[Ragnar1211]

Does this work for you?

=subtotal(2,range)

 

[jim may]

Thanks Gerry, but NO it doesn't...

Sorry for DUPLICATION - See

Limit A/F Record count to ONLY "SI" rows << Got Great Answer There !!!

 

[Dave Patton]

To calculate "Si" visible when database is filtered, try

=SUMPRODUCT(SUBTOTAL(103,OFFSET(B8,ROW(B8:B500)-ROW(B8),,1)),--(B8:B500="Si"))