Want to use count if in one worksheet and take data from another filtered worksheet

[Karro]

Hello!
I have a problem. I have two worksheets in a workbook. One worksheet have a table that is filtered. The other worksheet is the one where I want the data to go.

So, I want to count if there are "S1" in a column and that table is filtered in another column. (if that makes any sense)
I want that info to go in to the cell under 3.
Capture.PNG

The "S1" is in column C in worksheet "V". (worksheet "V" is filtered. I don't want the hidden data)
I want the data to go into a cell in worksheet "VA"

Thanks

[benishiryo]

hi there. maybe:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(V!$C$2,ROW(V!$C$2:$C$5)-ROW(V!$C$2),)))

it's explained in the file of my link below*Tips & Tutorials I Compiled, sheet 10

[Karro]

Does that only sum the total of "S1" or does it sum the total of everything in that column? Because I have "S1", "S2", "S3" and "S4", but I only want "S1".

[benishiryo]

ahh. missed that:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(V!$C$2,ROW(V!$C$2:$C$5)-ROW(V!$C$2),))*(V!$C$2:$C$5="S1"))

[Karro]

Okay, thank you! I will try that

[Karro]

It doesn't work. Does that formula look through all of column "C" or just between C2 and C5?