Hi, I know basic excel so I will try to explain my query as clear as possible. (apologies )

I have this formula below that count the rows if column H are labeled as "Approved" and column D have inputs except the word "Form"

=COUNTIFS(H10:H4608,"Approved",D10:D4608,"<>Form")


But I want to use filter. If I use filter I want the hidden rows to be excluded on the total.

What formula do I need to use? any tricks or suggestion.. Thank you in advance.