Friday, May 24, 2013

yogi_Pull In Column C List Of Phrases From Column A That Exclude Specified Words in Column B


                                          Google Spreadsheet   Post  #1208
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 24, 2013
user Les Olson Co (http://productforums.google.com/forum/?zx=txg71a902ibn#!category-topic/docs/spreadsheets/D97oUINbE-c)
Countif Does Range Does Not Contain Multiple Words.
I was able to get the formula below to work to count all cells in a range that DO NOT contain the word "Executive".

What I would like to do is find a formula that would count all of the cells in a range that do not contain ANY of the following words:
Executive
Purchasing
Administrative
Information
Office
Human
Custom
Sales
Accounts

=counta('Sheet 1'!E2:E300)-countif('Sheet 1'!E2:E300;"*Executive*")
------------------------------------------------------------------------------------------------------------------