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