EXCEL FIND SUM OF A COLUM IF ANOTHER CELL IS code example

Example: excel sum column if row contains

=SUMIF(range,"*"&A1&"*",sum_range)