Use MATCH and/or INDEX functions to find the following:

a) The row numbers corresponding to the first and last instance of item number 3166 in column C (be sure column C is sorted by order number).

b) The order cost associated with the first instance of item 3166 that you identified in part (a).

c) The total cost of all orders for item 3166. Use the answers to parts (a) and (b) along with the SUM function to do this. In other words, you should use the appropriate INDEX and MATCH functions within the SUM function to find the answer. Validate your results by applying the SUM function directly to the data in column G."

B C D E F G H M N. O Q R S T U V W X Y first row instance of item number 1369 12 last row instance of 1360 14 order cost for first order 1369 $ 63,000 C total cost for all order for item 1369 Order No. 4 Aug11001 5 Sep11006 6 Sep11011 7 Sep11014 8 Sep11032 9 Oct11006 10 Oct11020 11 Oct11032 12 Aug11002 13 Sep11008 14 Oct 11016 15 Sep11027 16 Sep11031 17 Sep11034 18 Aug11012 19 Sep11003 20 Sep11013 21 Sep11016 22 Sep 11007 23 Sep11015 24 Sep11019 25 Sep11022 26 Sep11026 27 Oct 11010 28 Oct 11022 29 Aug 11007 30 Sep11001 31 Sep11005 32 Oct 11011 33 Sep11012 34 Sep11020 35 Oct11001 36 Oct11005 37 Aug11014 38 Sep11004 39 Sep11010 40 Oct 11029 41 Aug 11005 42 Aug 11011 43 Sep11018 44 Sep11002 45 Oct11026 46 Oct11014 47 Oct 11023 Item No. Item Description Item Cost Quantity Cost per order A/P Terms (Months) 1122 Airframe fasteners $ 4.25 19,500 $ 82,875.00 30 1122 Airframe fasteners $ 4.25 15,500 $ 65,875.00 30 1122 Airframe fasteners $ 4.25 12,500 $ 53,125.00 30 1122 Airframe fasteners $ 4.25 15,000 $ 63,750.00 30 1122 Airframe fasteners $ 4.25 14,500 $ 61,625.00 30 1122 Airframe fasteners $ 4.25 18,000 $ 76,500.00 30 1122 Airframe fasteners $ 4.25 17,000 $ 72,250.00 30 1122 Airframe fasteners $ 4.25 17,500 $ 74,375.00 30 1243 Airframe fasteners $ 4.25 10,000 $ 42,500.00 30 1243 Airframe fasteners $ 4.25 9.000 $ 38,250.00 30 1243 Airframe fasteners $ 4.25 10,500 $ 44,625.00 30 1369 Airframe fasteners $ 4.20 15,000 $ 63,000.00 45 1369 Airframe fasteners $ 4.20 14,000 $ 58,800.00 45 1369 Airframe fasteners $ 4.20 10,000 $ 42,000.00 45 3166 Electrical Connector $ 1.25 5,600 $ 7,000.00 30 3166 Electrical Connector $ 1.25 5,500 $ 6,875.00 30 3166 Electrical Connector $ 1.25 5,650 $ 7,062.50 30 3166 Electrical Connector $ 1.25 5,425 $ 6,781.25 30 4111 Bolt-nut package $ 3.55 4,800 $ 17,040.00 25 4111 Bolt-nut package $ 3.55 4,585 $ 16,276.75 25 4111 Bolt-nut package $ 3.55 4,200 $ 14.910.00 25 4111 Bolt-nut package $ 3.55 4.250 $ 15,087.50 25 4111 Bolt-nut package $ 3.55 4,200 $ 14,910.00 25 4111 Bolt-nut package $ 3.55 4,600 $ 16,330.00 25 4224 Bolt-nut package $ 3.95 4,500 $ 17,775.00 30 4312 Bolt-nut package $ 3.75 4.250 $ 15,937.50 30 4312 Bolt-nut package $ 3.75 4.200 $ 15,750.00 30 4312 Bolt-nut package $ 3.75 4,150 $ 15,562.50 30 4569 Bolt-nut package $ 3.50 3.900 $ 13,650.00 45 5066 Shielded Cable/ft. $ 0.95 25,000 $ 23,750.00 30 5066 Shielded Cable/ft. S 0.95 17,500 $ 16,625.00 30 5125 Shielded Cable/ft. $ 1.15 15,000 $ 17,250.00 25 5166 Electrical Connector $ 1.25 5,650 $ 7,062.50 30 5234 Electrical Connector $ 1.65 4,500 $ 7,425.00 30 5234 Electrical Connector $ 1.65 4,850 $ 8,002.50 30 5234 Electrical Connector $ 1.65 4,750 $ 7,837.50 30 5275 Shielded Cable/ft $ 1.00 25,000 $ 25,000.00 45 5319 Shielded Cable/ft. $ 1.10 17,500 $ 19,250.00 30 5319 Shielded Cable/ft. $ 1.10 18,100 $ 19,910.00 30 5319 Shielded Cable/ft. $ 1.10 16,500 $ 18,150.00 30 5417 Control Panel $ 255.00 406 $ 103,530.00 30 5417 Control Panel $ 255.00 500 $ 127,500.00 30 5454 Control Panel $ 220.00 550 $ 121,000.00 45 5454 Control Panel $ 220.00 500 $ 110,000.00 45 Order Date 08/05/11 09/04/11 09/05/11 09/08/11 09/28/11 10/01/11 10/11/11 10/25/11 08/08/11 09/05/11 10/10/11 09/25/11 09/27/11 09/29/11 08/25/11 09/01/11 09/05/11 09/10/11 09/05/11 09/10/11 09/15/11 09/20/11 09/25/11 10/05/11 10/15/11 08/25/11 09/01/11 09/03/11 10/05/11 09/05/11 09/15/11 10/01/11 10/01/11 08/28/11 09/02/11 09/05/11 10/25/11 08/20/11 08/25/11 09/15/11 09/01/11 10/20/11 10/09/11 10/15/11 Arrival Date 08/13/11 09/12/11 09/11/11 09/15/11 10/03/11 10/08/11 10/19/11 11/03/11 08/14/11 09/12/11 10/17/11 09/30/11 10/03/11 10/04/11 08/29/11 09/06/11 09/10/11 09/15/11 09/20/11 09/30/11 10/15/11 10/10/11 10/25/11 10/19/11 10/20/11 09/01/11 09/10/11 09/11/11 10/10/11 09/12/11 09/22/11 10/15/11 10/06/11 09/05/11 09/11/11 09/13/11 10/30/11 08/31/11 09/05/11 10/05/11 09/10/11 10/27/11 10/14/11 10/20/11 B C D E F G H M N. O Q R S T U V W X Y first row instance of item number 1369 12 last row instance of 1360 14 order cost for first order 1369 $ 63,000 C total cost for all order for item 1369 Order No. 4 Aug11001 5 Sep11006 6 Sep11011 7 Sep11014 8 Sep11032 9 Oct11006 10 Oct11020 11 Oct11032 12 Aug11002 13 Sep11008 14 Oct 11016 15 Sep11027 16 Sep11031 17 Sep11034 18 Aug11012 19 Sep11003 20 Sep11013 21 Sep11016 22 Sep 11007 23 Sep11015 24 Sep11019 25 Sep11022 26 Sep11026 27 Oct 11010 28 Oct 11022 29 Aug 11007 30 Sep11001 31 Sep11005 32 Oct 11011 33 Sep11012 34 Sep11020 35 Oct11001 36 Oct11005 37 Aug11014 38 Sep11004 39 Sep11010 40 Oct 11029 41 Aug 11005 42 Aug 11011 43 Sep11018 44 Sep11002 45 Oct11026 46 Oct11014 47 Oct 11023 Item No. Item Description Item Cost Quantity Cost per order A/P Terms (Months) 1122 Airframe fasteners $ 4.25 19,500 $ 82,875.00 30 1122 Airframe fasteners $ 4.25 15,500 $ 65,875.00 30 1122 Airframe fasteners $ 4.25 12,500 $ 53,125.00 30 1122 Airframe fasteners $ 4.25 15,000 $ 63,750.00 30 1122 Airframe fasteners $ 4.25 14,500 $ 61,625.00 30 1122 Airframe fasteners $ 4.25 18,000 $ 76,500.00 30 1122 Airframe fasteners $ 4.25 17,000 $ 72,250.00 30 1122 Airframe fasteners $ 4.25 17,500 $ 74,375.00 30 1243 Airframe fasteners $ 4.25 10,000 $ 42,500.00 30 1243 Airframe fasteners $ 4.25 9.000 $ 38,250.00 30 1243 Airframe fasteners $ 4.25 10,500 $ 44,625.00 30 1369 Airframe fasteners $ 4.20 15,000 $ 63,000.00 45 1369 Airframe fasteners $ 4.20 14,000 $ 58,800.00 45 1369 Airframe fasteners $ 4.20 10,000 $ 42,000.00 45 3166 Electrical Connector $ 1.25 5,600 $ 7,000.00 30 3166 Electrical Connector $ 1.25 5,500 $ 6,875.00 30 3166 Electrical Connector $ 1.25 5,650 $ 7,062.50 30 3166 Electrical Connector $ 1.25 5,425 $ 6,781.25 30 4111 Bolt-nut package $ 3.55 4,800 $ 17,040.00 25 4111 Bolt-nut package $ 3.55 4,585 $ 16,276.75 25 4111 Bolt-nut package $ 3.55 4,200 $ 14.910.00 25 4111 Bolt-nut package $ 3.55 4.250 $ 15,087.50 25 4111 Bolt-nut package $ 3.55 4,200 $ 14,910.00 25 4111 Bolt-nut package $ 3.55 4,600 $ 16,330.00 25 4224 Bolt-nut package $ 3.95 4,500 $ 17,775.00 30 4312 Bolt-nut package $ 3.75 4.250 $ 15,937.50 30 4312 Bolt-nut package $ 3.75 4.200 $ 15,750.00 30 4312 Bolt-nut package $ 3.75 4,150 $ 15,562.50 30 4569 Bolt-nut package $ 3.50 3.900 $ 13,650.00 45 5066 Shielded Cable/ft. $ 0.95 25,000 $ 23,750.00 30 5066 Shielded Cable/ft. S 0.95 17,500 $ 16,625.00 30 5125 Shielded Cable/ft. $ 1.15 15,000 $ 17,250.00 25 5166 Electrical Connector $ 1.25 5,650 $ 7,062.50 30 5234 Electrical Connector $ 1.65 4,500 $ 7,425.00 30 5234 Electrical Connector $ 1.65 4,850 $ 8,002.50 30 5234 Electrical Connector $ 1.65 4,750 $ 7,837.50 30 5275 Shielded Cable/ft $ 1.00 25,000 $ 25,000.00 45 5319 Shielded Cable/ft. $ 1.10 17,500 $ 19,250.00 30 5319 Shielded Cable/ft. $ 1.10 18,100 $ 19,910.00 30 5319 Shielded Cable/ft. $ 1.10 16,500 $ 18,150.00 30 5417 Control Panel $ 255.00 406 $ 103,530.00 30 5417 Control Panel $ 255.00 500 $ 127,500.00 30 5454 Control Panel $ 220.00 550 $ 121,000.00 45 5454 Control Panel $ 220.00 500 $ 110,000.00 45 Order Date 08/05/11 09/04/11 09/05/11 09/08/11 09/28/11 10/01/11 10/11/11 10/25/11 08/08/11 09/05/11 10/10/11 09/25/11 09/27/11 09/29/11 08/25/11 09/01/11 09/05/11 09/10/11 09/05/11 09/10/11 09/15/11 09/20/11 09/25/11 10/05/11 10/15/11 08/25/11 09/01/11 09/03/11 10/05/11 09/05/11 09/15/11 10/01/11 10/01/11 08/28/11 09/02/11 09/05/11 10/25/11 08/20/11 08/25/11 09/15/11 09/01/11 10/20/11 10/09/11 10/15/11 Arrival Date 08/13/11 09/12/11 09/11/11 09/15/11 10/03/11 10/08/11 10/19/11 11/03/11 08/14/11 09/12/11 10/17/11 09/30/11 10/03/11 10/04/11 08/29/11 09/06/11 09/10/11 09/15/11 09/20/11 09/30/11 10/15/11 10/10/11 10/25/11 10/19/11 10/20/11 09/01/11 09/10/11 09/11/11 10/10/11 09/12/11 09/22/11 10/15/11 10/06/11 09/05/11 09/11/11 09/13/11 10/30/11 08/31/11 09/05/11 10/05/11 09/10/11 10/27/11 10/14/11 10/20/11