9 It is not letting me add the criteriarange 2 and it keep prompting me to start another formula I know the answer isn't right because I counted the blue shoes and I think the formula is technically stated correctly but I know there is an issue in the builder portion can you help b c 9 Use the SUMIFS function to calculate the total number of blue shoes in inventory Use the values in the Stock column as the Sum range argument Use the values in the Item Description column as the Criteria range1 argument and use the criteria shoes to find all items that end in the word shoes Use the values in the Color column as the Criteria range2 argument and use the criteria blue a Click cell B3 On the Formulas tab, in the Function Library group, click the Math Trig button and select SUMIFS In the Formula Builder task pane, verify that the cursor is in the Sum range argument box Click the Inventory sheet tab, and click and drag to select cells 13 125 d In the Formula Builder task pane, click the button to reveal the Criteria range1 argument box e Click in the Criteria range1 box and click the Inventory sheet tab, and click and drag to select cells A3 A25 f In the Formula Builder task pane, click the button to reveal the Criteria1 argument box Click in the Criterial box and type shoes to find any text string that ends with the word shoes h Click the button Click in the Criteria range2 argument box i Click the Inventory sheet tab, and click and drag to select cells C3 C25 j In the Formula Builder task pane, Click the button to reveal to the Criteria2 argument box k Click in the Criteria2 box and type blue 1 Click Done m The formula should look like this SUMIFS (Inventory 13 125, Inventory A3 A25, shoes , Inventory C3 225, blue ) g Function Used Time Trig Functions Defined Names D 7 Reference Function Library B3 4 x v fx SUMIFS(Inventory 13 125,Inventory A3 A25, shoes , Inventory C3 C25, blue ) A B 1 Inventory Analysis Average Selling 2 Total value of inventory $ 11,730 15 $ 3 Total number of blue shoes in inventory 17 4 Average selling price for blue shoes 5 Number of blue shoe inventory items 6 Inventory Lookup 8 9 Average Price of Football Items 10 11 Number of Football Items in Stock Sold for Less 12 Than $20 00 13 14 Price Lookup 15 Item Inventory Number FO 1002 16 Item Description 17 Quantity in Stock 18 Price 19 Where does this item rank in price 20 21 22 A B D E F G H Stock Category ID BA FO 7 11 BA 8 BA 10 BA 23 15 FL FL 17 24 FO FO BA 1 2 Item Description Inventory Number 3 Basic Basketball BA 1001 4 Basic Football FO 1001 5 Basketball Air Pump BA 2002 6 Basketball Goal BA 2000 7 Basketball Goal Net BA 2001 8 Flash Basketball FL 1001 9 Flash Football FL 1002 10 Football Air Pump FO 1003 11 Football Tee FO 1002 12 Junior Basketball BA 1002 13 Junior Football FO 1004 14 Youth Basketball BA 1002 15 Youth Basketball Shoes BA 5001 16 Youth Basketball Shoes BA 5002 17 Youth Basketball Shoes BA 5003 18 Youth Basketball Shoes BA 5004 19 Youth Basketball Shoes BA 5005 20 Youth Football Cleats FO 1005 21 Youth Football Cleats FO 5001 22 Youth Football Cleats FO 5002 23 Youth Football Cleats FO 5003 24 Youth Football Cleats FO 5004 25 Youth Football Cleats FO 5005 Hank's Sporting Goods Color Manufacturer Size Orange Cole Small Brown Cole Small Silver Zinks NA Black Zinks Regulation White Zinks Regulation Red Jackson Youth Blue Jackson Youth Black Zinks NA Orange Jackson Medium Brown Cole Small Cole Small Orange Cole Youth Red Assuage 4 to 3 Blue Nuke 4 to 3 Red Nuke 4 to 3 White Nuke 4 to 3 Gray Nuke 4 to 3 Brown Cole Youth Black Assuage 4 to 3 White Assuage 4 to 3 Red Nuke 4 to 3 Silver Assuage 4 to 3 Orange Assuage 4 to 3 Brown FO Cost Selling Price $ 6 10 $ 14 89 $ 6 10 $ 14 89 $ 3 80 $ 8 30 $ 16 60 $ 30 49 $ 1 50 $ 4 49 $ 3 80 $ 8 90 $ 4 95 $ 11 29 $ 4 95 $ 11 29 $ 1 50 $ 3 99 $ 7 25 $ 16 09 $ 7 25 $ 16 09 $ 6 10 $ 13 69 $ 23 35 $ 50 89 $ 25 65 $ 58 09 $ 26 80 $ 56 89 $ 23 35 $ 53 49 $ 24 50 $ 52 09 $ 7 25 $ 13 10 $ 30 25 $ 61 69 $ 30 25 $ 63 49 $ 31 40 $ 52 49 $31 40 $ 64 09 $ 31 40 $ 64 09 20 25 2 2 22 17 BA BA BA BA 13 BA 22 BA 6 22 FO FO 21 FO 25 8 FO FO FO 5 25 26 27 28 29

Question

9  It is not letting me add the criteriarange 2 and it keep prompting me to start another formula  I know the answer isn't right because I counted the blue shoes   and I think the formula is technically stated correctly but I know there is an issue in the builder portion    can you help  b c  9  Use the SUMIFS function to calculate the total number of blue shoes in inventory  Use the values in the Stock column as the Sum range argument  Use the values in the Item Description column as the Criteria range1 argument and use the criteria  shoes to find all items that end in the word shoes  Use the values in the Color column as the Criteria range2 argument and use the criteria blue  a  Click cell B3  On the Formulas tab, in the Function Library group, click the Math   Trig button and select SUMIFS  In the Formula Builder task pane, verify that the cursor is in the Sum range argument box  Click the Inventory sheet tab, and click and drag to select cells 13 125  d  In the Formula Builder task pane, click the   button to reveal the Criteria range1 argument box  e  Click in the Criteria range1 box and click the Inventory sheet tab, and click and drag to select cells A3 A25  f  In the Formula Builder task pane, click the   button to reveal the Criteria1 argument box  Click in the Criterial box and type   shoes  to find any text string that ends with the word shoes  h  Click the button  Click in the Criteria range2 argument box  i  Click the Inventory sheet tab, and click and drag to select cells C3 C25  j  In the Formula Builder task pane, Click the   button to reveal to the Criteria2 argument box  k  Click in the Criteria2 box and type   blue  1  Click Done  m  The formula should look like this   SUMIFS (Inventory 13 125, Inventory A3  A25,  shoes , Inventory C3 225, blue ) g Function Used Time Trig Functions Defined Names D 7 Reference Function Library B3 4 x v fx  SUMIFS(Inventory 13 125,Inventory A3 A25,  shoes , Inventory C3 C25, blue ) A B 1 Inventory Analysis Average Selling 2 Total value of inventory $ 11,730 15 $ 3 Total number of blue shoes in inventory 17 4 Average selling price for blue shoes 5 Number of blue shoe inventory items 6 Inventory Lookup 8 9 Average Price of Football Items 10 11 Number of Football Items in Stock Sold for Less 12 Than $20 00 13 14 Price Lookup 15 Item Inventory Number FO 1002 16 Item Description 17 Quantity in Stock 18 Price 19 Where does this item rank in price  20 21 22 A B D E F G H   Stock Category ID BA FO 7 11 BA 8 BA 10 BA 23 15 FL FL 17 24 FO FO BA 1 2 Item Description Inventory Number 3 Basic Basketball BA 1001 4 Basic Football FO 1001 5 Basketball Air Pump BA 2002 6 Basketball Goal BA 2000 7 Basketball Goal Net BA 2001 8 Flash Basketball FL 1001 9 Flash Football FL 1002 10 Football Air Pump FO 1003 11 Football Tee FO 1002 12 Junior Basketball BA 1002 13 Junior Football FO 1004 14 Youth Basketball BA 1002 15 Youth Basketball Shoes BA 5001 16 Youth Basketball Shoes BA 5002 17 Youth Basketball Shoes BA 5003 18 Youth Basketball Shoes BA 5004 19 Youth Basketball Shoes BA 5005 20 Youth Football Cleats FO 1005 21 Youth Football Cleats FO 5001 22 Youth Football Cleats FO 5002 23 Youth Football Cleats FO 5003 24 Youth Football Cleats FO 5004 25 Youth Football Cleats FO 5005 Hank's Sporting Goods Color Manufacturer Size Orange Cole Small Brown Cole Small Silver Zinks NA Black Zinks Regulation White Zinks Regulation Red Jackson Youth Blue Jackson Youth Black Zinks NA Orange Jackson Medium Brown Cole Small Cole Small Orange Cole Youth Red Assuage 4 to 3 Blue Nuke 4 to 3 Red Nuke 4 to 3 White Nuke 4 to 3 Gray Nuke 4 to 3 Brown Cole Youth Black Assuage 4 to 3 White Assuage 4 to 3 Red Nuke 4 to 3 Silver Assuage 4 to 3 Orange Assuage 4 to 3 Brown FO Cost Selling Price $ 6 10 $ 14 89 $ 6 10 $ 14 89 $ 3 80 $ 8 30 $ 16 60 $ 30 49 $ 1 50 $ 4 49 $ 3 80 $ 8 90 $ 4 95 $ 11 29 $ 4 95 $ 11 29 $ 1 50 $ 3 99 $ 7 25 $ 16 09 $ 7 25 $ 16 09 $ 6 10 $ 13 69 $ 23 35 $ 50 89 $ 25 65 $ 58 09 $ 26 80 $ 56 89 $ 23 35 $ 53 49 $ 24 50 $ 52 09 $ 7 25 $ 13 10 $ 30 25 $ 61 69 $ 30 25 $ 63 49 $ 31 40 $ 52 49 $31 40 $ 64 09 $ 31 40 $ 64 09 20 25 2 2 22 17 BA BA BA BA 13 BA 22 BA 6 22 FO FO 21 FO 25 8 FO FO FO 5 25 26 27 28 29

Accepted Answer

The Answer is in the image, click to view ...

Question

#9: It is not letting me add the criteriarange 2 and it keep prompting me to start another formula. I know the answer isn't right

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Introductory Accounting Finance And Auditing For Lawyers

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question