EXCEL USING SUM FUNCTION IN THE IF STATEMENT code example Example: EXCEL sum WITH condition SUMIF(range, criteria, [sum_range])