Hi everyone,

I'm using : Subtotal(3,K3:K8000) to count the number of cells that are not filtered on my worksheet.

Is there a way to combine another subtotal function with a countif.

I.e. I want the countif to only count the non filtered cells in the same way the subtotal does.

Regards