CountIF only on visible rows

[David Donker]

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?

 

[David Donker]

Ha thx a lot, this made the difference!

It only seems that the 'smaller than' formula must be done before the ''=''. So you get:
=SUMPRODUCT((Totaal!C3:C10000<=14)*SUBTOTAL(102;OFFSET(Totaal!C3;ROW(Totaal!C3:C10000)-ROW(Totaal!C3);0)))

Thanks for getting the formula to work and the explanation to why. I think I can get my entire workbook running now!