We are using this excel formula to display the owner pertinence (=SUMPRODUCT(SUBTOTAL(3,OFFSET($H$14:$H$26,ROW($H$14:$H$26)-MIN(ROW($H$14:$H$26)),,1)),ISNUMBER(SEARCH(G9,$H$14:$H$26))+0)). But when the columns are not filtered, it counst wrong lines that ends with a ".", like "Lexus." and "Trans.". When we filter the data, all workd well, its' when it is not filtered. We have included the excel. Please advice what we are doing wrong.