Spreadsheet: 864876d1712010673-sumifs-not-working-after-power-query-product-sales-import-into-this-2
Sheet: ProductSales

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10
 |  |  |  |  | Quantity | Sales_x000D_ ex VAT |  | VAT on_x000D_ Sales | Sales_x000D_ Value
TA DRINKS
TA HOT DRINKS |  |  |  |  |  |  |  |  |  |  |  | PRODUCT
202101 |  | TEA |  |  | 5.00 | £9.60 |  | £1.90 | £11.50 |  |  |  | QTY | OR PACKS
202104 |  | BLACK COFFEE |  |  | 14.00 | £35.56 |  | £7.14 | £42.70 |  |  | APPLE PIE SUNDAE
202105 |  | FLAT WHITE |  |  | 14.00 | £37.53 |  | £7.48 | £45.01 |  |  | BATH BUN |  |  |  |  |  |  |  |  | APPLE PIE
202106 |  | CAPPUCCINO |  |  | 11.00 | £29.37 |  | £5.83 | £35.20 |  |  | CARAMEL DOUGHNUT |  |  |  |  |  |  |  |  | APPLE PIE SUNDAE
202107 |  | LATTE |  |  | 19.00 | £51.49 |  | £10.26 | £61.75 |  |  | CARROT CAKE |  |  |  |  |  |  |  |  | AVOID GLUTEN APPLE PIE
202110 |  | MOCHA |  |  | 5.00 | £14.35 |  | £2.90 | £17.25 |  |  | CHOC COOKIE |  |  |  |  |  |  |  |  | BATH BUN
202115 |  | HOT CHOC - NO CREAM |  |  | 8.00 | £22.64 |  | £4.56 | £27.20 |  |  | [NAME] |  |  |  |  |  |  |  |  | BLACK COFFEE
 |  |  |  |  | 76.00 | £200.54 |  | £40.07 | £240.61 |  |  | CREAM SCONE |  |  |  |  |  |  |  |  | BLUEBERRY SLICE
 |  |  |  |  | 76.00 | £200.54 |  | £40.07 | £240.61 |  |  | CUP CAKE |  |  |  |  |  |  |  |  | BRIE AND CARAMELISED ONION CIABA
Report Total |  |  |  |  | 76.00 | £200.54 |  | £40.07 | £240.61 |  |  | ECCLES CAKE |  |  |  |  |  |  |  |  | BROWNIE
01 April 2024 |  |  |  |  |  |  | Page 1 of 1 |  |  |  |  | ECLAIR |  |  |  |  |  |  |  |  | CAPPUCCINO
Apple Pie Bakery |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | CARAMEL DOUGHNUT
 |  |  |  |  | Quantity | Sales_x000D_ ex VAT |  | VAT on_x000D_ Sales | Sales_x000D_ Value |  |  | FRUIT SCONE |  |  |  |  |  |  |  |  | CARAMEL SHORTBREAD
TA DRINKS |  |  |  |  |  |  |  |  |  |  |  | GINGER & LIME CHEESECAKE |  |  |  |  |  |  |  |  | CARROT CAKE
TA HOT DRINKS |  |  |  |  |  |  |  |  |  |  |  | HOT X BUN |  |  |  |  |  |  |  |  | CHEESE PASTY
202101 |  | TEA |  |  | 5.00 | £9.60 |  | £1.90 | £11.50 |  |  | HOT X BUN DOUGHNUT |  |  |  |  |  |  |  |  | CHEESE PASTY - COLD
202104 |  | BLACK COFFEE |  |  | 14.00 | £35.56 |  | £7.14 | £42.70 |  |  | JAM DOUGHNUT |  |  |  |  |  |  |  |  | CHEESE SCONE
202105 |  | FLAT WHITE |  |  | 14.00 | £37.53 |  | £7.48 | £45.01 |  |  | STICKY TOFFEE PUDDING |  |  |  |  |  |  |  |  | CHOC COOKIE
202106 |  | CAPPUCCINO |  |  | 11.00 | £29.37 |  | £5.83 | £35.20 |  |  | [NAME] |  |  |  |  |  |  |  |  | CHOCOLATE FUDGE ORANGE CAKE
202107 |  | LATTE |  |  | 19.00 | £51.49 |  | £10.26 | £61.75 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
202110 |  | MOCHA |  |  | 5.00 | £14.35 |  | £2.90 | £17.25 |  |  | TRAYBAKES |  |  |  |  |  |  |  |  | CORNISH PASTY
202115 |  | HOT CHOC - NO CREAM |  |  | 8.00 | £22.64 |  | £4.56 | £27.20 |  |  | BLUEBERRY SLICE |  |  |  |  |  |  |  |  | CORNISH PASTY - COLD
 |  |  |  |  | 76.00 | £200.54 |  | £40.07 | £240.61 |  |  | BROWNIE |  |  |  |  |  |  |  |  | [NAME] FOCCACIA
 |  |  |  |  | 76.00 | £200.54 |  | £40.07 | £240.61 |  |  | CARAMEL SHORTBREAD |  |  |  |  |  |  |  |  | CREAM SCONE
Report Total |  |  |  |  | 76.00 | £200.54 |  | £40.07 | £240.61 |  |  | FLAP JACK |  |  |  |  |  |  |  |  | CUP CAKE
01 April 2024 |  |  |  |  |  |  | Page 1 of 1 |  |  |  |  | GINGER BREAD |  |  |  |  |  |  |  |  | CUPCAKE
Apple Pie Bakery |  |  |  |  |  |  |  |  |  |  |  | RASP & COCONUT SLICE |  |  |  |  |  |  |  |  | ECCLES CAKE
 |  |  |  |  | Quantity | Sales_x000D_ ex VAT |  | VAT on_x000D_ Sales | Sales_x000D_ Value |  |  |  |  |  |  |  |  |  |  |  | ECLAIR
EAT IN FOOD |  |  |  |  |  |  |  |  |  |  |  | FILLED ROLLS |  |  |  |  |  |  |  |  | [NAME]
FILLED ROLLS |  |  |  |  |  |  |  |  |  |  |  | BRIE AND CARAMELISED ONION CIABA |  |  |  |  |  |  |  |  | FALAFEL WRAP
109101 |  | HAM & CHEESE FOCCACIA |  |  | 12 | £90.00 |  | £18.00 | £108.00 |  |  | [NAME] FOCCACIA |  |  |  |  |  |  |  |  | FELL TOP FLAPJACK
109102 |  | [NAME] FOCCACIA |  |  | 7 | £52.50 |  | £10.50 | £63.00 |  |  | CORONATION CAULIFLOWER CIABATTA |  |  |  |  |  |  |  |  | FLAP JACK
109103 |  | BRIE AND CARAMELISED ONION CIABA |  |  | 16 | £120.00 |  | £24.00 | £144.00 |  |  | FALAFEL WRAP |  |  |  |  |  |  |  |  | FLAT WHITE
109104 |  | PESTO CHICKEN BAGUETTE |  |  | 10 | £75.00 |  | £15.00 | £90.00 |  |  | HAM & CHEESE FOCACCIA |  |  |  |  |  |  |  |  | FRUIT SCONE
109106 |  | TUNA BAGUETTE |  |  | 10 | £75.00 |  | £15.00 | £90.00 |  |  | PESTO CHICKEN BAGUETTE |  |  |  |  |  |  |  |  | FRUIT SCONE & BUTTER
109304 |  | SALAD PLATE |  |  | 2 | £16.66 |  | £3.34 | £20.00 |  |  | TUNA BAGUETTE |  |  |  |  |  |  |  |  | GINGER & LIME CHEESECAKE
109306 |  | ORZO SALAD |  |  | 1 | £3.75 |  | £0.75 | £4.50 |  |  |  |  |  |  |  |  |  |  |  | GINGER BREAD
 |  |  |  |  | 58 | £432.91 |  | £86.59 | £519.50 |  |  | SAVOURIES |  |  |  |  |  |  |  |  | HAM & CHEESE FOCACCIA
SAVOURIES |  |  |  |  |  |  |  |  |  |  |  | CHEESE PASTY |  |  |  |  |  |  |  |  | HAM & CHEESE FOCCACIA
110101 |  | CORNISH PASTY |  |  | 6 | £43.74 |  | £8.76 | £52.50 |  |  | CHICKEN PIE |  |  |  |  |  |  |  |  | HOT CHOC - NO CREAM
110102 |  | CHEESE PASTY |  |  | 4 | £28.32 |  | £5.68 | £34.00 |  |  | CORNISH PASTY |  |  |  |  |  |  |  |  | HOT X BUN
110201 |  | SAUSAGE ROLL |  |  | 13 | £80.62 |  | £16.13 | £96.75 |  |  | LEBANESE ROLL |  |  |  |  |  |  |  |  | HOT X BUN DOUGHNUT
110301 |  | QUICHE |  |  | 7 | £49.56 |  | £9.94 | £59.50 |  |  | PREMIUM SAUS ROLL |  |  |  |  |  |  |  |  | ICED FINGER
110701 |  | CHEESE SCONE |  |  | 3 | £12.36 |  | £2.49 | £14.85 |  |  |  |  |  |  |  |  |  |  |  | JAM
 |  |  |  |  | 33 | £214.60 |  | £43.00 | £257.60 |  |  | APPLE PIES |  |  |  |  |  |  |  |  | JAM & CLOTTED CREAM
DESSERTS |  |  |  |  |  |  |  |  |  |  |  | APPLE PIE |  |  |  |  |  |  |  |  | JAM DOUGHNUT
113102 |  | TOASTED BATH BUN |  |  | 12 | £48.48 |  | £9.72 | £58.20 |  |  | SPICY APPLE PIE |  |  |  |  |  |  |  |  | KIDS CHEESE
113103 |  | HOT X BUN |  |  | 2 | £6.66 |  | £1.34 | £8.00 |  |  | TA GF APPLE PIE |  |  |  |  |  |  |  |  | KIDS HAM
113104 |  | TOASTED HOT X BUN |  |  | 19 | £63.27 |  | £12.73 | £76.00 |  |  | PLAIN APPLE SLICE |  |  | SLABS |  |  |  |  |  | LATTE
113105 |  | [NAME] |  |  | 5 | £20.20 |  | £4.05 | £24.25 |  |  | SPICY APPLE SLICE |  |  | SLABS |  |  |  |  |  | LEBANESE ROLL
113201 |  | PLAIN APPLE SLICE |  |  | 43 | £186.19 |  | £37.41 | £223.60 |  |  |  |  |  |  |  |  |  |  |  | MINI QUICHE
113202 |  | SPICY APPLE SLICE |  |  | 11 | £47.63 |  | £9.57 | £57.20 |  |  |  |  |  |  |  |  |  |  |  | MOCHA
113203 |  | AVOID GLUTEN APPLE PIE |  |  | 2 | £9.34 |  | £1.86 | £11.20 |  |  |  |  |  |  |  |  |  |  |  | ORZO SALAD
113204 |  | APPLE PIE SUNDAE |  |  | 1 | £5.25 |  | £1.05 | £6.30 |  |  |  |  |  |  |  |  |  |  |  | PESTO CHICKEN BAGUETTE
113206 |  | WITH ICE CREAM |  |  | 23 | £21.16 |  | £4.14 | £25.30 |  |  |  |  |  |  |  |  |  |  |  | PLAIN APPLE SLICE
113207 |  | WITH CUSTARD |  |  | 22 | £20.24 |  | £3.96 | £24.20 |  |  |  |  |  |  |  |  |  |  |  | PREMIUM SAUS ROLL
113213 |  | BROWNIE |  |  | 4 | £18.32 |  | £3.67 | £21.99 |  |  |  |  |  |  |  |  |  |  |  | PREMIUM SAUS ROLL - COLD
113220 |  | VEGAN CREAM |  |  | 2 | £2.26 |  | £0.44 | £2.70 |  |  |  |  |  |  |  |  |  |  |  | QUICHE
113301 |  | CARROT CAKE |  |  | 7 | £32.97 |  | £6.58 | £39.55 |  |  |  |  |  |  |  |  |  |  |  | RASP & COCONUT SLICE
113302 |  | CARAMEL DOUGHNUT |  |  | 5 | £21.20 |  | £4.26 | £25.46 |  |  |  |  |  |  |  |  |  |  |  | RASPBERRY & COCONUT SLICE
113303 |  | [NAME] |  |  | 10 | £42.10 |  | £8.40 | £50.50 |  |  |  |  |  |  |  |  |  |  |  | REMOVE DISCOUNT
113304 |  | ECLAIR |  |  | 0 | £0.00 |  | £0.00 | £0.00 |  |  |  |  |  |  |  |  |  |  |  | SALAD PLATE
113305 |  | [NAME] |  |  | 1 | £4.21 |  | £0.84 | £5.05 |  |  |  |  |  |  |  |  |  |  |  | SAUSAGE ROLL
113306 |  | FRUIT SCONE & BUTTER |  |  | 17 | £60.32 |  | £12.13 | £72.45 |  |  |  |  |  |  |  |  |  |  |  | [NAME] CIABATTA
113307 |  | JAM & CLOTTED CREAM |  |  | 14 | £7.48 |  | £1.52 | £9.00 |  |  |  |  |  |  |  |  |  |  |  | SPICY APPLE PIE
113309 |  | GINGER & LIME CHEESECAKE |  |  | 5 | £27.10 |  | £5.40 | £32.50 |  |  |  |  |  |  |  |  |  |  |  | SPICY APPLE SLICE
113310 |  | JAM |  |  | 1 | £0.25 |  | £0.05 | £0.30 |  |  |  |  |  |  |  |  |  |  |  | TA GF APPLE PIE
113311 |  | CHOCOLATE FUDGE ORANGE CAKE |  |  | 3 | £13.86 |  | £2.79 | £16.65 |  |  |  |  |  |  |  |  |  |  |  | TEA
113401 |  | ECCLES CAKE |  |  | 1 | £3.33 |  | £0.67 | £4.00 |  |  |  |  |  |  |  |  |  |  |  | TOASTED BATH BUN
113405 |  | FELL TOP FLAPJACK |  |  | 3 | £9.99 |  | £2.01 | £12.00 |  |  |  |  |  |  |  |  |  |  |  | TOASTED HOT X BUN
113407 |  | RASPBERRY & COCONUT SLICE |  |  | 0 | £0.00 |  | £0.00 | £0.00 |  |  |  |  |  |  |  |  |  |  |  | TUNA BAGUETTE
113408 |  | BLUEBERRY SLICE |  |  | 3 | £9.99 |  | £2.01 | £12.00 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
113411 |  | CUPCAKE |  |  | 4 | £17.00 |  | £3.40 | £20.40 |  |  |  |  |  |  |  |  |  |  |  | VEGAN CREAM
 |  |  |  |  | 220 | £698.80 |  | £140.00 | £838.80 |  |  |  |  |  |  |  |  |  |  |  | WITH CUSTARD
 |  |  |  |  | 311 | £1,346.31 |  | £269.59 | £1,615.90 |  |  |  |  |  |  |  |  |  |  |  | WITH ICE CREAM
TA FOOD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
TA FILLED ROLLS
207101 |  | HAM & CHEESE FOCACCIA |  |  | 12 | £58.25 |  | £0.00 | £58.25
207102 |  | TUNA BAGUETTE |  |  | 8 | £41.20 |  | £0.00 | £41.20
207103 |  | PESTO CHICKEN BAGUETTE |  |  | 13 | £66.67 |  | £0.00 | £66.67
207201 |  | [NAME] CIABATTA |  |  | 4 | £21.00 |  | £0.00 | £21.00
207301 |  | FALAFEL WRAP |  |  | 9 | £47.25 |  | £0.00 | £47.25
207406 |  | KIDS HAM |  |  | 4 | £12.00 |  | £0.00 | £12.00
207407 |  | KIDS CHEESE |  |  | 0 | £0.00 |  | £0.00 | £0.00
 |  |  |  |  | 50 | £246.37 |  | £0.00 | £246.37
TA SAVOURIES
208201 |  | CORNISH PASTY |  |  | 54 | £220.02 |  | £44.28 | £264.30
208202 |  | CHEESE PASTY |  |  | 24 | £92.68 |  | £18.46 | £111.14
208301 |  | PREMIUM SAUS ROLL |  |  | 105 | £313.20 |  | £62.64 | £375.84
208302 |  | LEBANESE ROLL |  |  | 16 | £43.36 |  | £8.64 | £52.00
208501 |  | CORNISH PASTY - COLD |  |  | 1 | £4.15 |  | £0.00 | £4.15
208502 |  | CHEESE PASTY - COLD |  |  | 5 | £19.50 |  | £0.00 | £19.50
208601 |  | PREMIUM SAUS ROLL - COLD |  |  | 11 | £33.00 |  | £0.00 | £33.00
208603 |  | MINI QUICHE |  |  | 5 | £22.50 |  | £0.00 | £22.50
 |  |  |  |  | 221 | £748.41 |  | £134.02 | £882.43
TA SWEETS
209101 |  | BATH BUN |  |  | 234 | £441.54 |  | £0.00 | £441.54
209103 |  | [NAME] |  |  | 34 | £88.40 |  | £0.00 | £88.40
209104 |  | ICED FINGER |  |  | 14 | £23.10 |  | £0.00 | £23.10
209105 |  | HOT X BUN |  |  | 494 | £531.71 |  | £0.00 | £531.71
209201 |  | PLAIN APPLE SLICE |  |  | 25 | £60.14 |  | £0.00 | £60.14
209202 |  | SPICY APPLE SLICE |  |  | 33 | £80.85 |  | £0.00 | £80.85
209203 |  | APPLE PIE |  |  | 31 | £167.17 |  | £0.00 | £167.17
209204 |  | SPICY APPLE PIE |  |  | 27 | £150.35 |  | £0.00 | £150.35
209205 |  | TA GF APPLE PIE |  |  | 1 | £4.88 |  | £0.00 | £4.88
209302 |  | CARROT CAKE |  |  | 2 | £7.30 |  | £0.00 | £7.30
209304 |  | CUP CAKE |  |  | 23 | £66.75 |  | £0.00 | £66.75
209305 |  | ECLAIR |  |  | 7 | £23.10 |  | £0.00 | £23.10
209306 |  | [NAME] |  |  | 38 | £110.35 |  | £0.00 | £110.35
209307 |  | [NAME] |  |  | 27 | £85.78 |  | £0.00 | £85.78
209308 |  | CARAMEL DOUGHNUT |  |  | 32 | £103.10 |  | £0.00 | £103.10
209309 |  | CREAM SCONE |  |  | 20 | £66.00 |  | £0.00 | £66.00
209311 |  | ECCLES CAKE |  |  | 29 | £78.93 |  | £0.00 | £78.93
209401 |  | FRUIT SCONE |  |  | 16 | £26.15 |  | £0.00 | £26.15
209402 |  | HOT X BUN DOUGHNUT |  |  | 21 | £34.08 |  | £0.00 | £34.08
209403 |  | JAM DOUGHNUT |  |  | 42 | £68.04 |  | £0.00 | £68.04
209405 |  | CHOC COOKIE |  |  | 11 | £24.41 |  | £0.00 | £24.41
209501 |  | GINGER BREAD |  |  | 106 | £182.72 |  | £0.00 | £182.72
209503 |  | CARAMEL SHORTBREAD |  |  | 39 | £71.09 |  | £0.00 | £71.09
209505 |  | BROWNIE |  |  | 14 | £27.46 |  | £0.00 | £27.46
209508 |  | FLAP JACK |  |  | 64 | £113.27 |  | £0.00 | £113.27
209510 |  | BLUEBERRY SLICE |  |  | 9 | £19.68 |  | £0.00 | £19.68
209512 |  | RASP & COCONUT SLICE |  |  | 12 | £23.60 |  | £0.00 | £23.60
REMDISC |  | REMOVE DISCOUNT |  |  | 67 | £0.00 |  | £0.00 | £0.00
 |  |  |  |  | 1472 | £2,679.95 |  | £0.00 | £2,679.95
 |  |  |  |  | 1743 | £3,674.73 |  | £134.02 | £3,808.75
Report Total |  |  |  |  | 2054 | £5,021.04 |  | £403.61 | £5,424.65
29-Mar-24 |  |  |  |  |  |  | Page 1 of 1
Apple Pie Bakery
From: | 01/04/2024 |  | To: | 01/04/2024
From: | 31/03/2024 |  | To: | 31/03/2024