VBA - Count filtered rows in the table

[sandy666]

each filter filters the values of the remaining rows and not all, only the first filter filters the total (100).
you can test it using only the last filter with the rest left blank (don't know if it will work on xl2013)




hope it's clear now

more options



or



you insisted on showing the filter results and I don't want it, maybe this description will be better: filter1 - show count filtered1 rows AND count left rows after filter1, then filter2 shows count rows from left rows after filter1 - it will be count2 filtered and left2 after filter2 , and etc