if statement - EXCEL - IF multiple strings in a range of cells -
server type count enterprise 3 standard 24 enterprise core 6 in excel, looking check if server type (a2-a5) contains both 'enterprise' , 'enterprise core' or 'enterprise'. if contains both, add 2 numbers together, otherwise, display number 'enterprise'. perhaps this: =sumif(a:a,"enterprise",b:b)+sumif(a:a,"enterprise core",b:b) if doesn't have both .. it'll find 1 add ..