if and sumif formula in excel code example Example: excel sumif =SUMIF (range, criteria, [sum_range])