Spreadsheet: 745953d1630402395-if-search-and-sum-totals
Sheet: Sheet1

 | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales | Sales Total | Stock |  |  |  |  |  |  | 2021 | Stock
Branch | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 |  |  |  |  |  |  |  | Branches | Sales
Showroom1 |  |  |  |  |  | 6 | 6 | 15 | 27 |  |  |  |  |  |  | Showroom1 | 24 | 2
Showroom2 |  |  |  |  |  |  | 5 | 5 | 10 |  |  |  |  |  |  | Showroom2 | 11 | 2
Showroom3 |  |  |  |  |  |  | 1 | 2 | 3 | 1 |  |  |  |  |  | Showroom3 | 10 | 1
Showroom4 |  |  |  |  |  |  | 3 | 3 | 6 |  |  |  |  |  |  | Showroom4 | 6 | 0
Showroom5 |  |  |  |  |  | 9 | 8 | 9 | 26 | 1 |  |  |  |  |  | Showroom5 | 15 | 4
Showroom6 |  |  |  |  |  | 1 | 3 | 1 | 5 | 2 |  |  |  |  |  | Showroom6 | 4 | 3
Showroom7 |  |  |  |  |  |  | 4 | 5 | 9 |  |  |  |  |  |  | Showroom7 | 6 | 2
Showroom8 |  |  |  |  |  |  | 7 | 7 | 14 | 1 |  |  |  |  |  | Showroom8 | 13 | 2
Showroom9 |  |  |  | 1 |  | 4 | 7 | 9 | 21 | 2 |  |  |  |  |  | Showroom9 | 16 | 3
Showroom10 |  |  |  |  |  | 3 | 3 | 4 | 10 |  |  |  |  |  |  | Showroom10 | 7 | 2
Showroom11 |  |  |  |  |  |  | 4 | 3 | 7 | 2 |  |  |  |  |  | Showroom11 | 5 | 3
Showroom1 |  |  |  | 3 | 2 | 7 | 6 | 9 | 27 | 2 |  |  |  |  |  | Showroom12 | 0 | 0
Showroom2 |  |  |  | 1 |  | 7 | 8 | 6 | 22 | 2 |  |  |  |  |  | Showroom13 | 0 | 0
Showroom3 |  |  |  |  |  |  | 7 | 8 | 15 |  |  |  |  |  |  | Showroom14 | 0 | 0
Showroom4 |  |  |  |  |  |  | 2 | 3 | 5 |  |  |  |  |  |  | Showroom15 | 0 | 0
Showroom5 |  |  |  |  | 8 | 8 | 4 | 6 | 26 | 3 |  |  |  |  |  | Showroom16 | 0 | 0
Showroom6 |  |  |  |  |  |  | 5 | 3 | 8 | 1 |  |  |  |  |  | Showroom17 | 0 | 0
Showroom7 |  |  |  |  |  | 2 | 1 | 1 | 4 | 2 |  |  |  |  |  | [NAME] | 0 | 0
Showroom8 |  |  |  |  |  |  | 2 | 6 | 8 | 1 |  |  |  |  |  | Showroom19 | 0 | 0
Showroom9 |  |  |  |  | 2 | 6 | 9 | 7 | 24 | 1 |  |  |  |  |  | Showroom20 | 0 | 0
Showroom10 |  |  |  |  |  | 1 | 5 | 3 | 9 | 2 |  |  |  |  |  | Showroom21 | 0 | 0
Showroom11 |  |  |  |  |  |  | 5 | 2 | 7 | 1 |  |  |  |  |  | Showroom22 | 0 | 0
Showroom23 |  |  |  |  | 1 | 5 | 4 | 6 | 16 | 1 |  |  |  |  |  | Showroom23 | 6 | 1
Showroom24 |  |  |  |  |  | 4 | 3 | 3 | 10 | 1 |  |  |  |  |  | Showroom24 | 3 | 1
Showroom25 |  |  |  |  |  |  | 2 |  | 2 |  |  |  |  |  |  | Showroom25 | 0 | 0
Showroom26 |  |  |  |  |  | 3 | 4 | 5 | 12 |  |  |  |  |  |  | Showroom26 | 5 | 0
Showroom27 |  |  |  |  |  |  |  | 5 | 5 |  |  |  |  |  |  | Showroom27 | 5 | 0
Showroom28 |  |  |  |  |  | 8 | 16 | 10 | 34 | 2 |  |  |  |  |  | Showroom28 | 10 | 2
[NAME] |  |  |  |  | 4 | 6 | 5 | 3 | 18 | 1 |  |  |  |  |  | [NAME] | 3 | 1
Showroom30 |  |  |  |  |  |  | 3 |  | 3 | 2 |  |  |  |  |  | Showroom30 | 0 | 2
Showroom31 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | Showroom31 | 0 | 1
Showroom32 |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  | Showroom32 | 0 | 0
Showroom33 |  |  |  | 1 |  | 4 | 11 | 9 | 25 | 1 |  |  |  |  |  | Showroom33 | 9 | 1
Showroom34 |  |  |  | 2 |  | 6 | 15 | 9 | 32 |  |  |  |  |  |  | Showroom34 | 9 | 0
Showroom35 |  |  |  |  |  | 4 | 5 | 3 | 12 | 1 |  |  |  |  |  | Showroom35 | 3 | 1
Showroom36 |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  | Showroom36 | 1 | 1
Showroom37 |  |  |  |  |  | 3 | 10 | 8 | 21 | 2 |  |  |  |  |  | Showroom37 | 8 | 2
Showroom38 |  |  |  |  |  | 3 | 5 | 4 | 12 | 2 |  |  |  |  |  | Showroom38 | 4 | 2
Showroom39 |  |  |  |  |  | 3 | 9 | 7 | 19 |  |  |  |  |  |  | Showroom39 | 7 | 0
Showroom40 |  |  |  | 2 |  | 1 | 8 | 4 | 15 | 2 |  |  |  |  |  | Showroom40 | 4 | 2
Showroom41 |  |  |  |  |  |  | 3 | 1 | 4 | 1 |  |  |  |  |  | Showroom41 | 1 | 1
Showroom42 |  |  |  |  | 2 |  | 3 | 4 | 9 | 3 |  |  |  |  |  | Showroom42 | 4 | 3
Showroom43 |  |  |  |  |  |  | 3 | 2 | 5 |  |  |  |  |  |  | Showroom43 | 2 | 0
Showroom44 |  |  |  |  |  | 5 | 6 | 4 | 15 |  |  |  |  |  |  | Showroom44 | 4 | 0
Showroom45 |  |  |  |  |  | 2 | 6 | 5 | 13 | 4 |  |  |  |  |  | Showroom45 | 5 | 4
Showroom46 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | Showroom46 | 0 | 2
Showroom47 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  | Showroom47 | 0 | 2
Showroom48 |  |  |  |  |  |  | 2 | 1 | 3 |  |  |  |  |  |  | Showroom48 | 1 | 0
Showroom49 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | Showroom49 | 0 | 1
Total |  |  |  | 10 | 19 | 111 | 229 | 211 | 580 | 54 |  |  |  |  |  | Showroom50 | 0 | 0