excel sum column if row contains code example Example: excel sum column if row contains =SUMIF(range,"*"&A1&"*",sum_range)