Help: COUNTIFS EXCLUDING HIDDEN ROWS?

[conky4]

I know countifs counts everything including hidden rows...so how would I modify my formula with a different command to NOT COUNT hidden rows based on criteria?

This is what my formula is now:
=SUM(COUNTIFS(D3:D40,{"12","10","8*","8","OT*","TRADE*","DENIED"})) which counts up everything even if hidden, I need it to count up anything that fits those criteria but exclude the manually hidden rows. Not sure how to modify it.

 

[Jonmo1]

Using a helper column, say E for example..

E3 and filled down to E40
=SUBTOTAL(103,D3)

Then add a criteria to your countifs to test that column for 1

=SUM(COUNTIFS(E3:E40,1,D3:D40,{"12","10","8*","8","OT*","TRADE*","DENIED"}))

 

[conky4]

Using a helper column, say E for example..

E3 and filled down to E40
=SUBTOTAL(103,D3)

Then add a criteria to your countifs to test that column for 1

=SUM(COUNTIFS(E3:E40,1,D3:D40,{"12","10","8*","8","OT*","TRADE*","DENIED"}))

Is there any way to do it maybe with a different command without adding a helper column?