David Donker
New Member
- Joined
- Apr 23, 2013
- Messages
- 16
Hi guy's,
The title of this speaks for itself. At the moment I'm using checkboxes to hide some rows, and I want to count the visible rows with a certain value.
Originally I used this formula:
=COUNTIF(Totaal!B3:B10000;"V")
But this also counts the hidden rows. How can I only count the visible rows with this formula?
The title of this speaks for itself. At the moment I'm using checkboxes to hide some rows, and I want to count the visible rows with a certain value.
Originally I used this formula:
=COUNTIF(Totaal!B3:B10000;"V")
But this also counts the hidden rows. How can I only count the visible rows with this formula?