M MrDeeds New Member Joined Nov 30, 2005 Messages 17 Feb 29, 2012 #1 Trying to enter a sumif for a column that contains comma separated. colB = "Florida, Tampa"...I need to sumif for Tampa. So, sumif colE when it finds Tamps in colB. Any ideas? Thanks.