=SUMPRODUCT(–ISNUMBER(SEARCH(C1,$B$2:$B$5)))
Lets break it down..
Read more about Quirky functions
For help and more information join our community, follow the blog or follow me on Twitter
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines