1. In cell M11, create a dcount to determine the number of orders that were placed for pencils. Use the criteria range starting in cell O1.

2. In cell M12, create a daverage formula to determine the average total sale of Binders. Use the criteria range starting in cell Q1.

AP48 Whitman Kivell CentralSorvino 10 Order Date Region Nested 11 7/12/15 East 12 7/29/15 East 13 8/15/15 East 14 9/1/15 Central Rep IF Rep Item Units Unit Cost Total Cost Total Sale Pencil: Binder Binder 81 19.99 2 125.00 16 15 99 15 9/18/15 East 16 10/5/15 Central 17 10/22/15 East Pen Set Binder East Pen Sale 18 11/8/15 East 19 11/25/15 Central 20 12/12/15 Central 21 12/29/15 East 15 19.99 Pen Set 20 30 Pen Set Binder 74 15.99 $1.99 $199 22 1/15/16 Central 24 : 2/18/16 East 2/1/16 Central 87 15.00 $2.29 3/7/16 West 7 19.99 $2.39 Pen Set 263/24/16 Central 27 4/10/16 Central 28 4/27/16 East 29 5/14/16 Central 30 5/31/16 Central $2.59 $2.69 1.29 $2.79 Binder Desk Pen Set Pen Set Pen Set 5 125.00 $2.99 31 6/17/16 Centra 7/4/16 East 55 12 49 42 23.95 3 275.00 1.29 33 7/21/16 Central 8/7/16 Central 35 8/24/16 West 36 9/10/16 Central 37 9/27/16 West 38 10/14/16 West 39 10/31/16 Central 40 11/17/16 Central 57 19.99 1.29 Binder Binder 94 19.99 4.99 12/4/16 Central 42 12/21/16 Central Sheett Sheet2 Sheet3 Ready Scroll Lock Type here to search