Rx_
Nothing In Moderation
- Local time
- Today, 03:03
- Joined
- Oct 22, 2009
- Messages
- 2,803
The formula below works perfectlly. It counts only the rows in column C that are not hidden from applied filters the other columns.
The request is to show the bold and light rows, but only count the the Bold rows visible.
Please view the attachment. It shows a small part of a big Excel report that is custom generated in Access from code.
Code in Cell D4 (see attachment)
=SUMPRODUCT(SUBTOTAL(3, OFFSET(C6:C5997, ROW(C6:C5997)-ROW(C6),0,1)),--(C6:C5997=C4))
Code works perfectlly to count only the visible rows when filters are applied.
Cell C4 (shows Navigator Header Created) is a pull-down list cell.
Users can select a value and D4 displays the count of all visible rows.\
A Bold row for an item is always present. The light rows can be zero to many.
The request is to show the bold and light rows, but only count the the Bold rows visible.
Please view the attachment. It shows a small part of a big Excel report that is custom generated in Access from code.
Code in Cell D4 (see attachment)
=SUMPRODUCT(SUBTOTAL(3, OFFSET(C6:C5997, ROW(C6:C5997)-ROW(C6),0,1)),--(C6:C5997=C4))
Code works perfectlly to count only the visible rows when filters are applied.
Cell C4 (shows Navigator Header Created) is a pull-down list cell.
Users can select a value and D4 displays the count of all visible rows.\
A Bold row for an item is always present. The light rows can be zero to many.