# Tricky Count of Unhidden Rows

#### jim may

##### Well-known Member
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)
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

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### Ragnar1211

##### Well-known Member
Does this work for you?

=subtotal(2,range)

#### jim may

##### Well-known Member
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

##### Well-known Member
To calculate "Si" visible when database is filtered, try

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

Replies
6
Views
488
Replies
29
Views
1K
Replies
5
Views
380
Replies
7
Views
727
Replies
0
Views
259

1,191,032
Messages
5,984,241
Members
439,879
Latest member
KingGoulash

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back