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