An alternative approach is to introduce a column of values which are always 1 for visible rows and always 0 for hidden rows, so in D2 enter:

=1*(SUBTOTAL(103,A2:C2)>0) and copy down

Then if you want to count visible fords:

=SUMPRODUCT(--(A2:A100="ford")*(B2:B100)*(D2:D100))