Step-by-Step 1 – Using the SUMIF Function

Excel calculates your formula, returning a value of $742,000. 8. Select . C23 . and in the Function Library group, click . Recently Used. 9. Select . SUMIF S. In the Sum_range box, select . C5:C16. 10. In the Criteria_range1 box, select cells . F5:F16. Type ................
................