How to Countif filtered data

Hi all

I have excel file. I want to count data in filter with no duplicate data.

for example: SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B44,ROW(B2:B44)-MIN(ROW(B2:B44)),,1)),ISNUMBER(SEARCH("2010 - Q2",B2:B44))+0)
But it still count all data in that colume by duplicate data.