excel - sum value in column when cells contains certain text code example Example: excel sum column if row contains =SUMIF(range,"*"&A1&"*",sum_range)