This is what the excel sheet looks like. How do I in cell B18 to E20, use a formula with a pre-defined function to calculate the total quantity sold for Hand sanitizer, First aid kit, Water bottle, & Toothbrush kit during the week according to the store location.
Product Price AUD
Water bottle Suitcase Packing Cube Toothbrush kit Towel First aid kit Neck pillow Adapter Torch Padlock Walking shoes Hand sanitizer 9 49 20 22 10 39 12 60 29 19 99 8
Week 1 Sales
Water bottle Suitcase Packing Cube Toothbrush kit Towel First aid kit Neck pillow Adapter Torch Padlock Walking shoes Hand sanitizer Airport 37 18 64 37 38 47 84 114 98 32 109 63 CBD Shopping Centre 45 0 0 27 77 67 70 13 73 33 0 74 CBD Station 78 76 58 58 42 34 0 17 30 49 18 35
Total Quantity Sold (category) 160 94 122 122 157 148 154 144 201 114 127 172
Total Sales Amount(AUD)(category) $1,440.00 $4,606.00 $2,440.00 $2,684.00 $1,570.00 $5,772.00 $1,848.00 $8,640.00 $5,829.00 $2,166.00 $12,573.00 $1,376.00
Stay Healthy Items Sale per Store Store Hand sanitizer First aid kit Water bottle Airport CBD Shopping Centre CBD Station Toothbrush kit