=GROUPBY(row_fields, values, function, [field Headers], [total_depth], [sort order], [filter_array], [field relationship])

I would like to use the FILTER ARRAY for search and group partial text matches, for instance Venus would find “Venus Printing Company” or “The Planet Venus”. Has anyone found a workaround to do this?

=GROUPBY(B:B,C:C,SUM,0,0,,B:B=”Venus Stores Company”) successfully pulls and filters “Venus Stores Company” but I would also like to have =GROUPBY(B:B,C:C,SUM,0,0,,B:B=” wildcard Venus wildcard”) or =GROUPBY(B:B,C:C,SUM,0,0,,B:B= “wilcard” & “Venus Stores Company” & “wildcard”) to work and neither do.