Can you Combine a Subtotal and Countif? How?

[RBusiness]

Hello folks,

I'm trying to count how many times a call A2 appears in a list within another sheet but only when it's visible (not filtered from view).
I've been trying to combined a subtotal and countif, but it's not working.

Does anyone have an example to share that might help?
My formula would go in B2 and look to see how many times A2 appears in A:A of another sheet - but again - only if it's visible.

Your help is truly appreciated!

TY,
R

 

[cspengel]

Maybe something like this?

=SUMPRODUCT(SUBTOTAL(3,OFFSET(Sheet1!A2:A15,ROW(Sheet1!A2:A15)-ROW(Sheet1!A2),0,1)),--(Sheet1!A2:A15=A2))