Hi, I have a big spreadsheet that links into many others.
I normally use a countif but it counts all of the data even when using a filter.
I only want it to only count the filtered data.
So how would I go about this?

This is my current countif:
=COUNTIF(Q1_Data,B4)

Q1_Data= A different worksheet (=Sheet1!$B$13:$AD$4717)
B4 = Text "Post Sales"

Thanks