A B D E F 8 A. Create a "SUMIF" formula to total the amount of seed available based on commodity. Last Amount Germ Last 9 Location Commodity Variety (lbs) Date Germ % 0 113 Broccoli Verde 175 20-Jul 98 114 Broccoli Verde 325 20-Jul 98 12 114 Broccoli Husky 140 20-May 99 13 115 Iceberg Fat Head 70 20-Jun 97 14 116 Romaine Green Giant 140 20-Mar 98 15 116 Romaine Crisp 325 20-Aug 99 16 116 Romaine Crisp 175 20-Jul 99 17 117 Spinach El Guapo 25 20-Apr 97 18 118 Spinach El Guapo 40 20-Apr 97 19 119 Spinach Greenheart 30 19-Nov 98 20 120 Iceberg Sundown 140 20-Aug 97 21 120 Iceberg Sundown 70 20-Aug 97 22 120 Iceberg Heat Seeker 325 19-Sep 99 23 121 Romaine Green Giant 175 20-Mar 98 24 SPINACH AVAILABLE 25 ROMAINE AVAILABLE 26 ICEBERG AVAILABLE 27 BROCCOLI AVAILABLE 28 29 Instructions 1080 Seed Results + Ready