Hello. I'm new to this forum. I tried all of the solution to this problem but it keeps me giving a unusual result. Is there something wrong with my formula?

=SUMPRODUCT(SUBTOTAL(103,OFFSET('REINSPECTION W/ OVR'!J3:J,ROW('REINSPECTION W/ OVR'!J3:J)-MIN(ROW('REINSPECTION W/ OVR'!J3:J)),0))*('REINSPECTION W/ OVR'!J3:J="PAID"))

I need to know how many has paid in my filtered data. When I use this sort of formula the result is way off.

I hope someone will help me. Thanks!