ABCDEFGHIJKLMNOPQRSTUVWX
1
2
3
Orders Table
4
Order IDRegionCountryBrandSKUYearQMDateUSDPacksSUMIFS
5
139EastBulgariaBountyBounty2017Q1322.03.2017555000750Use
Return the SUM of Specified Column, where rows meet the specified condition(s)
6
196EastBulgariaBountyBounty2017Q2425.04.2017370000500
Sum Sales per Year per Brand in 1 Formula
Syntax
SUMIFS(sum_range,criteria_range1,criteria1,...)
7
448EastBulgariaBountyBounty2017Q3901.09.2017555000750Brand20172018201920202021sum_rangeThe column containing the value to sum
8
832EastBulgariaBountyBounty2018Q1327.03.2018592000800Bounty11٬517٬88115٬258٬2253٬496٬2973٬591٬5671٬722٬926criteria_range1The column containing Criteria 1
9
1329EastBulgariaBountyBounty2018Q41115.11.2018518000700Cadbury412٬4481٬886٬3223٬859٬4968٬344٬08710٬123٬905criteria1Criteria 1
10
1611EastBulgariaBountyBounty2019Q2407.04.2019-47040Cheetos0٬0000٬0000٬0001٬4251٬441٬566…remember SUMIFS runs with Single Criteria, or Multiple if needed
11
1709EastBulgariaBountyBounty2019Q2518.05.2019-1931٫040Doritos-48٬81262٬646395٬178747٬1332٬321٬639
12
1828EastBulgariaBountyBounty2019Q3721.07.20191931٫040Galaxy4٬710٬9998٬201٬9428٬225٬4625٬268٬5377٬063٬822
13
2940EastBulgariaBountyBounty2021Q1115.01.2021-6635٫040Haribo0٬0000٬0000٬000212٬2721٬494٬500
14
3088EastBulgariaBountyBounty2021Q1323.03.202147040Kinder16٬634٬17019٬034٬38824٬016٬17425٬831٬18833٬798٬000
15
868EastBulgariaCadburyCadbury Small2018Q2414.04.201813343456KitKat0٬0000٬000257٬7154٬002٬4045٬675٬168
16
1570EastBulgariaCadburyCadbury Small2019Q1315.03.201910007٫550Lays28٬504٬45924٬196٬27313٬642٬69813٬149٬4749٬394٬890
17
1641EastBulgariaCadburyCadbury Small2019Q2419.04.2019-20015٫10Loaker-2٬835٬9459٬158٬48817٬687٬25328٬723٬88931٬125٬903
18
2165EastBulgariaCadburyCadbury Small2020Q1101.01.202066121٫3130M&Ms61٬797٬27769٬526٬40178٬809٬46779٬212٬04393٬931٬484
19
2345EastBulgariaCadburyCadbury Small2020Q1322.03.2020263675٫11120Mars0٬0000٬0000٬0000٬0001٬923٬561
20
2417EastBulgariaCadburyCadbury Small2020Q2420.04.2020222608٫42101Milka0٬0000٬0000٬0000٬000343٬665
21
3194EastBulgariaCadburyCadbury Small2021Q2502.05.2021224812٫46102Oreo16٬126٬19619٬352٬65926٬272٬71223٬610٬16527٬209٬247
22
3310EastBulgariaCadburyCadbury Small2021Q2621.06.2021810٫140Pepsi11٬420٬77012٬931٬85610٬505٬61915٬749٬85618٬472٬727
23
3496EastBulgariaCadburyCadbury Small2021Q3919.09.2021473869٫41215Pringles13٬141٬1459٬655٬5618٬179٬2669٬460٬5407٬520٬347
24
3007EastBulgariaCheetosCheetos Small2021Q1216.02.2021131750250Sneakers0٬0000٬0002٬993٬05813٬435٬9749٬786٬868
25
3612EastBulgariaCheetosCheetos Large2021Q41109.11.2021892840Twix13٬854٬56612٬645٬44316٬437٬90621٬610٬64025٬733٬461
26
1439EastBulgariaDoritosDoritos Large2019Q1114.01.2019120780550
27
1624EastBulgariaDoritosDoritos Large2019Q2411.04.2019-120780
28
2286EastBulgariaDoritosDoritos Large2020Q1225.02.2020120780600West
Packs Per Quarter Per Year Per Region in 1 Formula
29
2877EastBulgariaDoritosDoritos Large2020Q41216.12.2020-1207802020QuarterPacks
30
3379EastBulgariaDoritosDoritos Large2021Q3723.07.20212964601500Q119٬241٬722
31
3420EastBulgariaDoritosDoritos Large2021Q3814.08.2021219380٫41110Q28٬746٬466
32
3574EastBulgariaDoritosDoritos Large2021Q41018.10.20212174041100Q313٬552٬134
33
162EastBulgariaGalaxyGalaxy2017Q2409.04.2017148850٫54100Q415٬984٬711
34
275EastBulgariaGalaxyGalaxy2017Q2601.06.2017148850٫54100
35
362EastBulgariaGalaxyGalaxy2017Q3714.07.201774425٫2750
36
542EastBulgariaGalaxyGalaxy2017Q41020.10.2017-11286٫770
37
729EastBulgariaGalaxyGalaxy2018Q1203.02.2018206902٫24139
38
955EastBulgariaGalaxyGalaxy2018Q2523.05.2018223275٫81150
39
1037EastBulgariaGalaxyGalaxy2018Q3708.07.2018297701٫08200
40
1087EastBulgariaGalaxyGalaxy2018Q3727.07.201816373٫5511
41
1437EastBulgariaGalaxyGalaxy2019Q1113.01.2019-2655٫170
42
1484EastBulgariaGalaxyGalaxy2019Q1202.02.2019444620٫57300
43
1906EastBulgariaGalaxyGalaxy2019Q3904.09.201928724٫1318
44
2285EastBulgariaGalaxyGalaxy2020Q1224.02.2020297701٫07200
45
2649EastBulgariaGalaxyGalaxy2020Q3822.08.202039827٫570
46
2828EastBulgariaGalaxyGalaxy2020Q41121.11.20203620٫6930
47
2971EastBulgariaGalaxyGalaxy2021Q1201.02.2021431067٫36409
48
3208EastBulgariaGalaxyGalaxy2021Q2507.05.2021148850٫54100
49
3269EastBulgariaGalaxyGalaxy2021Q2605.06.2021225610٫27209
50
3519EastBulgariaGalaxyGalaxy2021Q3927.09.20212772٫240
51
3121EastBulgariaHariboHaribo2021Q2405.04.2021103216٫68230
52
488EastBulgariaKinderKinder2017Q3918.09.20175487751626
53
534EastBulgariaKinderKinder2017Q41016.10.201743200120
54
557EastBulgariaKinderKinder2017Q41028.10.20174083751189
55
637EastBulgariaKinderKinder2017Q41211.12.20175602501650
56
994EastBulgariaKinderKinder2018Q2614.06.201857600160
57
1157EastBulgariaKinderKinder2018Q3826.08.201872000200
58
1344EastBulgariaKinderKinder2018Q41123.11.201812069003540
59
1348EastBulgariaKinderKinder2018Q41124.11.201811677503400
60
1815EastBulgariaKinderKinder2019Q3714.07.201912645003700
61
2072EastBulgariaKinderKinder2019Q41122.11.20195040001400
62
2142EastBulgariaKinderKinder2019Q41220.12.201912150003500
63
2203EastBulgariaKinderKinder2020Q1118.01.202011205003300
64
2318EastBulgariaKinderKinder2020Q1311.03.20204430001300
65
2346EastBulgariaKinderKinder2020Q1322.03.202021330006300
66
2947EastBulgariaKinderKinder2021Q1117.01.20214245001200
67
3485EastBulgariaKinderKinder2021Q3914.09.202115171604400
68
3670EastBulgariaKinderKinder2021Q41207.12.2021349200970
69
77EastBulgariaLaysLays 300mg2017Q1216.02.2017222758٫754030
70
90EastBulgariaLaysLays 300mg2017Q1223.02.2017280784٫715024
71
276EastBulgariaLaysLays 300mg2017Q2601.06.20172220004000
72
742EastBulgariaLaysLays 300mg2018Q1210.02.20182775005000
73
800EastBulgariaLaysLays 300mg2018Q1310.03.2018-189٫770
74
1083EastBulgariaLaysLays 300mg2018Q3725.07.2018393654٫767055
75
1110EastBulgariaLaysLays 300mg2018Q3808.08.2018-166٫460
76
1418EastBulgariaLaysLays 300mg2019Q1103.01.2019-139٫320
77
35EastBulgariaLoakerLoaker - Small2017Q1117.01.2017810010
78
659EastBulgariaLoakerLoaker - Small2017Q41222.12.2017-399052313
79
693EastBulgariaLoakerLoaker - Small2018Q1117.01.2018-15000000
80
883EastBulgariaLoakerLoaker - Small2018Q2421.04.201810094502050
81
1076EastBulgariaLoakerLoaker - Small2018Q3723.07.201830364504050
82
1106EastBulgariaLoakerLoaker - Small2018Q3806.08.201823055422998
83
1680EastBulgariaLoakerLoaker - Small2019Q2505.05.201951030007000
84
1848EastBulgariaLoakerLoaker - Small2019Q3805.08.201936974885072
85
2116EastBulgariaLoakerLoaker - Small2019Q41209.12.20197690951055
86
2177EastBulgariaLoakerLoaker - Small2020Q1107.01.2020394119010310
87
2793EastBulgariaLoakerLoaker - Small2020Q41105.11.20203645050
88
2800EastBulgariaLoakerLoaker - Small2020Q41110.11.202044432556095
89
3055EastBulgariaLoakerLoaker - Small2021Q1309.03.202173629101
90
3391EastBulgariaLoakerLoaker - Small2021Q3726.07.2021464400012500
91
3554EastBulgariaLoakerLoaker - Small2021Q41010.10.2021390619810262
92
22EastBulgariaM&MsM&Ms 300mg2017Q1111.01.201713252٫4130
93
48EastBulgariaM&MsM&Ms 240mg2017Q1201.02.20172479167٫116285
94
71EastBulgariaM&MsM&Ms 400mg2017Q1214.02.201713696٫2915
95
91EastBulgariaM&MsM&Ms 400mg2017Q1223.02.2017506341٫12765
96
148EastBulgariaM&MsM&Ms 160mg2017Q1327.03.20176566402505
97
231EastBulgariaM&MsM&Ms 500mg2017Q2513.05.20172137525
98
296EastBulgariaM&MsM&Ms 160mg2017Q2609.06.2017821669٫13095
99
329EastBulgariaM&MsM&Ms 40mg2017Q2625.06.2017513075
100
349EastBulgariaM&MsM&Ms 500mg2017Q3706.07.2017855010