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