Spreadsheet: 858505d1707163737-count-baseed-on-certain-criteria-samplecountdata_etaf
Sheet: Sheet1

 |  |  | [NAME] |  |  |  | 11
 |  |  | What is the count of  Colum H with x and endcap only
[NAME] to enter  this field |  |  |  |  |  |  | Purcell | Suburban | Warr
 | Component/Item Definitions |  |  | Attr 3 | Attr 4 | Attr 5 | 10 | 9 | 13
Customer Item # | Major Component | Long Description | Short Description | [NAME] Only |  |  | 18231 | 17575 | 17927 | SIGN TYPE
 | Window Poster | 4CP/4CP | 26" x 34" | Sale 3 For $9.99 Scotts Nature Scapes Color Enhanced Mulch, 2 CF - 7394695, 7394703, 7394711 RHB | Poster [NAME] |  |  |  | X | X | X
 | Window Poster | 4CP/4CP | 26" x 34" | New At Ace Launch Party 4/27 | Poster Launch Party |  |  |  | X | X | X
 | End Cap ML | 4CP/4 | 34" x 18.25" | 1 - Ace SmartFLO Max 50' Premium Garden Hose - $34.99-$5.00=$29.99 - 7637085 -Limit 2 - RHB REVERSE:  Hydrate Your Lawn (show image 7637085) | End Cap 1-SmartFLO Max Garden Hose |  |  |  | X | X | X | End Cap
 | End Cap ML | 4CP/0 | 34" x 18.25" | Hydrate Your Lawn | End Cap Hydrate Your Lawn |  |  |  | X | X | X | End Cap
 | End Cap ML | 4CP/4 | 34" x 18.25" | 2 - Buy Round Up Dual Action Weed & Grass Killer Pls 4 Month Preventer Gal. 7016356 $37.99, Get FREE Dual Action Weed & Grass Killer Refill, 1.25 Gal. 7016353 - Limit 2  RHB REVERSE:  Manager's Special | End Cap 2 Round Up Dual Action W&G |  |  |  | X | X | X | End Cap
 | End Cap ML | 4CP/4 | 34" x 18.25" | 5 - Ace Insect Killers - 7415136, 7415128, 7415144, 7415110 - 2 For $8.00 - $4.00 each - RHB  REVERSE:  [NAME] | End Cap 5 Ace Insect Killers |  |  |  | X | X | X | End Cap
 | End Cap ML | 4CP/4 | 34" x 18.25" | 6 - C&S [NAME], 11.75 Oz. 80795, 80799, 8003584, 8003592 Sale $1.49 each - Assorted varieties - RHB  REVERSE: April Savings | End Cap 6 C&S [NAME] |  |  |  |  |  |  | End Cap
 | End Cap ML | 4CP/4 | 34" x 18.25" | 7 - Buy CRAFTSMAN V20 Battery & Starter Kit Sale $99.00 2834232, Get FREE Select CRAFTSMAN V20 Power Tools (bare tools) 2005821, 2026516, 2862886, 2862910  2894004, 8063959 RHB - No Limit REVERSE:  We Do Screen Repair | End Cap 7 [NAME] V20 [NAME] |  |  |  | X | X | X | End Cap
 | End Cap ML | 4CP/4 | 34" x 18.25" | 8 - Grill Cleaner messaging ([NAME]'s you can use 8951408, 8059736, 8065858, 8068328, 8211062, 8687048)  REVERSE:  Spring Has Sprung | End Cap 8 Grill [NAME] |  |  |  | X | X | X | End Cap
 | Optional End Cap ML | 4CP/0 | 34" x 18.25" | Sale 2 For $6.00 Sprayaway Stainless Steel Cleaner & Polish or [NAME], 1696079 $3.00 each RHB | End [NAME]Cleaner & Polish |  |  |  | X | X | X | End Cap
 | Window Poster | 4CP/4CP | 26" x 34" | [NAME] Poster - Spend $60 Save $10.00  Lawn Weed Killer 7008393, 7008397 | Poster - BMAS Spend $60 Save $10 |  |  |  | X | X | X
 | End Cap ML | 4CP/0 | 34" x 18.25" | [NAME] -Spend $60 Save $10.00  Lawn Weed Killer 7008393, 7008397 | EndCap - BMAS Spend $60 Save $10 |  |  |  | X | X | X | End Cap
 | 9-Up Price Sign |  4CP/0 | 16.5" x 10 x 5" | BMAS BOGO Cards - Spend $60 Save $10.00  Lawn Weed Killer 7008393, 7008397 | BOGO Cards - BMAS Spend $60 Save $10 |  |  |  | X | X | X
 | Price Sign |  4CP/0 | 11" x 7" | BMAS 11x7 Sign- Spend $60 Save $10.00  Lawn Weed Killer 7008393, 7008397 | 11x7-BMAS Spend $60 Save $10 |  |  |  | X | X | X
 | Circular [NAME] | 4CP/0 | 22" x 23.25" | [NAME]/Month Long w/QR Code | [NAME]/Month Long w/QR Code |  |  |  | X | X | X
 | [NAME] | 1/0 | 6.125" x 2.625" | April Bagstuffer $5 Off $25 4/1-4/30 ( Barcode 90326950-DP140550) | Bagstuffer $5 Off $25 |  |  |  | X | X | X
 | Countermat [NAME] | 4CP/0 | 11" x 17" | Deal of the Month RHB - Terro Ant Kille Granules 3LB $11.99 - $4.00 = $5.99 | Countermat [NAME] |  |  |  | X | X | X
 | 9-Up Price Sign |  4CP/0 | 16.5" x 10 x 5" | RHB BOGO Cards - BMAS / Duel Action Weed & Grass Killer Refill, | BOGOCards BMAS/Duel Action W&G Killer |  |  |  | X | X | X
 | 9-Up Price Sign |  4CP/0 | 16.5" x 10 x 5" | RHB BOGO Cards - Bird Seed / Sauces & Rubs | BOGO CARDS-BirdSeed/Sauces/Rubs |  |  |  | X | X | X
 | 9-Up Price Sign |  4CP/0 | 16.5" x 10 x 5" | RHB BOGO Cards - Filtrete 1000 Allergen Air Filters /DEWALT 20V MAX Power Tools | BOGO Cards AirFilters / DEWALT 20v |  |  |  | X | X | X
 | 9-Up Price Sign |  4CP/0 | 16.5" x 10 x 5" | RHB BOGO Cards - Milwaukee M18 FUEL REDLITHIUM  /Craftsman V20 Battery & Charger Starter Kit 2834232 | BOGO Cards Milwaukee [NAME] |  |  |  | X | X | X
 | End Cap ML | 4CP/0 | 34" x 18.25" | New At Ace Launch Party | End Cap New At Ace Launch Party |  |  |  | X | X | X | End Cap
 | Recipe Card | 4CP/ 4 | 8-1/2"x5.5"| padded 60# | New At Ace Launch Party Recipe Card | Recipe Card New At Ace Launch Party |  |  |  | X | X | X
 | 17"x11" |  4CP/4 Folded Playbook | New At Ace Launch Party Playbook (12 pages) | Playbook New At Ace Launch Party |  |  |  | X | X | X
 | KOOZIE-VendorSupplied | New At Ace Launch Party - KOOZIE | KOOZIE |  |  |  | X | X | X
 | [NAME] | 4CP/0 | 34" x 18.25" | CMN Customized Endcaps | End Cap CMN |  |  |  | X | X | X | End Cap
 | B2B Sell Sheet 8.5x11 | B2B Sell Sheet 8.5x11 - April Product Opportunity | B2B April Sell Sheet |  |  |  | X | X | X
 | B2B Tip Sheet 8.5x11 | B2B Tip Sheet 8.5x11 | B2B April Tip Sheet |  |  |  | X | X | X
 | [NAME] | 4/4 | 6.125" x 2.625" | C+K [NAME] | Bagstuffer C+K Good Housekeeping |  |  |  | X | X | X
 | Poster | Retail Training Helpful Poster | Poster-Retail Training Helpful |  |  |  | X | X | X
 | End Cap ML | 4CP/4 | 34" x 18.25" | SPECTRACIDE TRIAZICIDE SKU: 7114197,7215197, 7435290 SALES $9.99  2$ AR $7.99 | SPECTRACIDE TRIAZICIDE |  |  |  |  |  |  | End Cap
 | End Cap ML | 4CP/4 | 34" x 18.25" | THOMPSON WATERSEALER SKU 126984, 1094184 SALE $26.99 $2 AR $24.99 | THOMPSON WATERSEALER |  |  |  |  |  |  | End Cap
 | End Cap ML | 4CP/4 | 34" x 18.25" | ZINSSER123 PRMR/SEALR GL SKU 16890 | ZINSSER 123 |  |  |  |  |  |  | End Cap
 | End Cap ML | 4CP/4 | 34" x 18.25" | SATCO OUTDOOR LIGHTING SKU S8020, S11290, S8034 | SATCO LIGHTING |  |  |  |  |  |  | End Cap
 | End Cap ML | 4CP/4 | 34" x 18.25" | SPECTRACIDE BUG STOP/WEED CNTRL SKU 7327612, 7465305, 7002736 | SPECTRACIDE BUG STOP/WEED CNTRL |  |  |  |  |  |  | End Cap
 | End Cap ML | 4CP/4 | 34" x 18.25" | BUY CRAFTSMAN V20 SCRUBBER SKU 1031966 AT $166.99 GET SKU 1030263 OR 1031972 FOR FREE | CRAFTSMAN V20 SCRUBBER |  |  |  | X |  | X | End Cap