Countif with filters

[fakinami]

Hey guys,

I've been trying to use a countif expression that allows me to check for misplaced data, which is pretty easy, however it becomes a lot more tricky when i try to make that same data respond to filters. This is the expression i have used so far COUNTIFS('A. Sensibilização'!C3:C1048576;"<>";'A. Sensibilização'!C3:C1048576;"<>Eletric";'A. Sensibilização'!C3:C1048576;"<>Construction";'A. Sensibilização'!C3:C1048576;"<>Others"), but i can't apply filters this way, so i tried using a subtotal+sumproduct but unsuccessful so far. Any ideas that can help me?

Thanks in advance!

 

[fakinami]

Sorry, the expression should be this one =COUNTIFS(D7:D1048576;"<>";D7:D1048576;"<>Electric";D7:D1048576;"<>Construction";D7:D1048576;"<>Others")