Allow countif (and countifs) to count cells where I am searching an array for a string value. For example, if I have a table with dates in one column and names in another column, but I may have multiple names in a single cell, I want to be able to count the number of cells that have John listed even if that cell also has Jane as a value.
Good suggestion Omar, thanks for posting. We’ll prioritize this according to votes – so please keep voting for the ideas you like most!
John [MS XL]
Brad Yundt commented
With wildcard characters, you already have this capability:
The above formula counts the number of cells in B2:B10 that contain "John", no matter what text (if any) occurs in those cells before or after "John". The asterisk * wildcard character means any combinations of characters (including none). The question mark ? wildcard character also works in COUNTIF and SUMIF, and means any single character.