Step-by-Step 1 – Explore Functions

In the Number1 box, type B5:B16 and click OK. Select C28 and in the Function Library group, click Insert Function. Select AVERAGEIF from the function list or use the function search box to locate and accept. In the Function Arguments dialog box, in the Range box, select cells B5:B16. In the Criteria box… ................
................