Spreadsheet: 758953d1639168595-countifs-with-blank-criteria-countifs-with-blank-criteria
Sheet: Summary

type_of_skincare | key_ingredients | skin_type
Attribute 1 ID | Attribute 1 | Attribute 1 ValueID | Attribute 2 ID | Attribute 2 | Attribute 2 ValueID | Attribute 3 ID | Attribute 3 | Attribute 3 ValueID | Category URL.URL | Products with attribute value 1 present | Products with JUST attribute value 2 | Products with JUST attribute value 3 | Combined | Expected
 | Body Gems |  |  |  |  |  |  |  | beauty-health/skin-care |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Criteria 1 | [NAME] | Criteria 3 |  |  |  |  | Fruit | Price | Season
 | [NAME] |  |  |  |  |  |  |  | beauty-health/skin-care |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apple | 18 | Autumn | 0 |  |  |  | Apple | 45 | Autumn
 | Body Pearls |  |  |  |  |  |  |  | beauty-health/skin-care |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apple | 45 |  | 2 |  |  |  | Orange | 15 | Winter
 | Cleanser |  |  |  |  |  |  |  | beauty-health/skin-care |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Summer | 0 |  |  |  | [NAME] | 16 | Summer
 | Day Cream |  |  |  |  |  |  |  | beauty-health/skin-care |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | [NAME] | 18 | Summer
 | Exfoliator |  |  |  |  |  |  |  | beauty-health/skin-care |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | Apple | 45 | Autumn
 | Face Scrub |  |  |  |  |  |  |  | beauty-health/skin-care |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | Orange | 56 | Winter
 | Facial Oil |  |  |  |  |  |  |  | beauty-health/skin-care |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | [NAME] | 76 | Summer
 | Hemp Tattoo |  |  |  |  |  |  |  | beauty-health/skin-care |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | [NAME] | 45 | Summer
 | Henna Tattoo |  |  |  |  |  |  |  | beauty-health/skin-care
 | Sheet Face Masks |  |  |  |  |  |  |  | beauty-health/skin-care
 | Massage Machine |  |  |  |  |  |  |  | beauty-health/skin-care
 | Massage Oil |  |  |  |  |  |  |  | beauty-health/skin-care
 | Massage Stool |  |  |  |  |  |  |  | beauty-health/skin-care
 | Night Cream |  |  |  |  |  |  |  | beauty-health/skin-care
 | [NAME] |  |  |  |  |  |  |  | beauty-health/skin-care
 | [NAME] |  |  |  |  |  |  |  | beauty-health/skin-care
 | Semi Permanent Tattoo |  |  |  |  |  |  |  | beauty-health/skin-care
 | Serum |  |  |  |  |  |  |  | beauty-health/skin-care
 | [NAME] |  |  |  |  |  |  |  | beauty-health/skin-care
 | Temporary Tattoo & Body Jewels |  |  |  |  |  |  |  | beauty-health/skin-care
 | Toner |  |  |  |  |  |  |  | beauty-health/skin-care
 | Eye Care |  |  |  |  |  |  |  | beauty-health/skin-care |  |  |  |  | 12 | Expect 12 because 12 products have 'eye care'
 | Moisturiser |  |  |  |  |  |  |  | beauty-health/skin-care
 | Eye Care |  |  | Amber |  |  |  |  | beauty-health/skin-care |  |  |  |  | 2 | Expect 2 because only 2 products have both 'eye care' and 'amber'
 |  |  |  | [NAME] |  |  |  |  | beauty-health/skin-care
 |  |  |  | Amber |  |  |  |  | beauty-health/skin-care
 |  |  |  | Argan Oil |  |  |  |  | beauty-health/skin-care
 |  |  |  | Atropine |  |  |  |  | beauty-health/skin-care
 |  |  |  | [NAME] |  |  |  |  | beauty-health/skin-care
 |  |  |  | BCAA |  |  |  |  | beauty-health/skin-care
 |  |  |  | Berry |  |  |  |  | beauty-health/skin-care
 |  |  |  | [NAME] |  |  |  |  | beauty-health/skin-care
 |  |  |  | Cactus |  |  |  |  | beauty-health/skin-care
 |  |  |  | Caffeine |  |  |  |  | beauty-health/skin-care
 |  |  |  | Calcite |  |  |  |  | beauty-health/skin-care
 |  |  |  | [NAME] |  |  |  |  | beauty-health/skin-care
 |  |  |  | Cereal |  |  |  |  | beauty-health/skin-care
 |  |  |  | Charcoal |  |  |  |  | beauty-health/skin-care
 |  |  |  | Chocamine |  |  |  |  | beauty-health/skin-care
 |  |  |  | Chocolate |  |  |  |  | beauty-health/skin-care
 |  |  |  | Cocoa Butter |  |  |  |  | beauty-health/skin-care
 |  |  |  | Coconut |  |  |  |  | beauty-health/skin-care |  |  |  |  | 10 | Expect 10 because only 10 products have 'Coconut' present in attributes
 | Cleanser |  |  | Coconut |  |  | Aged |  | beauty-health/skin-care |  |  |  |  | 3 | Expect 3 because 3 products match all 3 criteria 'Cleanser', 'Coconut','Aged'
 |  |  |  | Coconut |  |  | Aged |  | beauty-health/skin-care |  |  |  |  | 2 | Expect 2 because only 2 products have both 'coconut' and 'aged'
 |  |  |  |  |  |  | [NAME] |  | beauty-health/skin-care |  |  |  |  | 4 | Expect 4 because 4 products have 'acne prone'
 |  |  |  |  |  |  | Aged |  | beauty-health/skin-care |  |  |  |  | 15 | Expect 15 because 15 products have 'aged'
 |  |  |  |  |  |  | Blemish Prone |  | beauty-health/skin-care
 |  |  |  |  |  |  | Combination |  | beauty-health/skin-care
 |  |  |  |  |  |  | Cracked |  | beauty-health/skin-care
 |  |  |  |  |  |  | [NAME] |  | beauty-health/skin-care
 |  |  |  |  |  |  | [NAME] |  | beauty-health/skin-care
 |  |  |  |  |  |  | Dry Skin |  | beauty-health/skin-care
 |  |  |  |  |  |  | Dull Skin |  | beauty-health/skin-care
 |  |  |  |  |  |  | Eczema |  | beauty-health/skin-care
 |  |  |  |  |  |  | Firming |  | beauty-health/skin-care
 |  |  |  |  |  |  | Itchy |  | beauty-health/skin-care
 |  |  |  |  |  |  | Mature |  | beauty-health/skin-care
 |  |  |  |  |  |  | Normal |  | beauty-health/skin-care
 |  |  |  |  |  |  | Normal & Combination |  | beauty-health/skin-care
 |  |  |  |  |  |  | Oily |  | beauty-health/skin-care
 |  |  |  |  |  |  | Pigment |  | beauty-health/skin-care
 |  |  |  |  |  |  | Psoriasis |  | beauty-health/skin-care
 |  |  |  |  |  |  | Radiant |  | beauty-health/skin-care
 |  |  |  |  |  |  | Red Spots |  | beauty-health/skin-care
 |  |  |  |  |  |  | Rosacea |  | beauty-health/skin-care
 |  |  |  |  |  |  | Sensitive |  | beauty-health/skin-care
 |  |  |  |  |  |  | Sun Intolerant |  | beauty-health/skin-care
 |  |  |  |  |  |  | [NAME] |  | beauty-health/skin-care
 |  |  |  |  |  |  | Scally Skin |  | beauty-health/skin-care
 |  |  |  |  |  |  | All Skins |  | beauty-health/skin-care |  |  |  |  | 10 | Expect 10 because 10 products have 'All skins'