Spreadsheet: 716314d1612172744-summing-an-area-when-a-condition-is-met-example
Sheet: Example

Ordered For…... | Shop | Click&Collect | Market | Wholesale | Other |  |  |  |  |  |  |  |  |  |  | [NAME]…... | 1900-01-02 00:00:00 |  |  |  |  |  |  | Notes
Product | Amount |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helper Cells
[NAME] |  | 2 | 10 | 12 | 12 |  |  | For example.. Total [NAME] should be 7 |  |  |  |  |  |  |  | Breads |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-02 00:00:00
[NAME] |  | 0 | 16 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-03 00:00:00
Bakewell Tart |  | 2 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Cheese and Onion Bread
[NAME] | 2 | 0 | 5 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Eight Grain |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-04 00:00:00
Beef Pasty |  | 0 | 5 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-05 00:00:00
Brownie |  | 12 | 12 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | French Stick |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-06 00:00:00
Cheese and Onion Bread |  | 0 | 5 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Granary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-07 00:00:00
Cheese and Onion Pasty |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Rye
Chelsea Buns |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Sourdough
Chicken and [NAME] |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Spelt
Chocolate Croissant |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  | Walnut
Eight Grain |  | 0 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | White Tin
[NAME] |  | 0 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | White Rolls
French Stick |  | 0 | 20 |  |  |  |  |  |  |  |  |  |  |  |  | Wholemeal
Granary |  | 123 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | Wholemeal Rolls
Brioche Doughnut |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | Ciabatta
Large Quiche |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Millionaire Shortbread |  | 0 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | White Tin (Small)
Pain aux raisins |  | 2 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Plain Croissant |  | 0 | 12 |  |  |  |  |  |  |  |  |  |  |  |  | Sourdough - Wholemeal
Portuguese [NAME] |  | 1 | 18 |  |  |  |  |  |  |  |  |  |  |  |  | Sourdough - Granary
Rye |  | 0 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | Sourdough - Quinoa
Sausage Roll |  | 0 | 10 |  |  |  |  |  |  |  |  |  |  |  |  | Sour Dough- 7 Cereales
Small Quiche |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | Pain Au Mais
Sourdough |  | 0 | 40
Spelt |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Walnut |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
White Tin |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | Pain aux raisins
White Rolls |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | Plain Croissant
Wholemeal |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate Croissant
Wholemeal Rolls |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pain Au Chocolate
Ciabatta |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sweet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bakewell Tart
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Brownie
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chelsea Buns
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Brioche Doughnut
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Millionaire Shortbread
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Portuguese [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chocolate Doughnuts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Savoury Hot
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beef Pasty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cheese and Onion Pasty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chicken and [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sausage Roll