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 ..
Comments
Post a Comment