sum rows excel based on condition code example
Example 1: excel sum column if row contains
=SUMIF(range,"*"&A1&"*",sum_range)
Example 2: EXCEL sum WITH condition
SUMIF(range, criteria, [sum_range])
=SUMIF(range,"*"&A1&"*",sum_range)
SUMIF(range, criteria, [sum_range])