Spreadsheet: 840732d1692945639-sumproduct-formula-to-find-avg-from-multiple-column-excel-forum2
Sheet: DB (2)

Booked Date | Quarter | Order Number | Project Name | Sales Manager Name | Stream | Sell Price | List Price | PBU Disc.% | Sell Price - For commission | Stream Factor | Commissionable Amount (after stream factor) | Sub Region (New) | Region (New) | PBU | Collection Factor % | Commissionable Amount (after Collection factor) | Discount
2023-03-29 00:00:00 | Q1 | 12345678 | Pita 1246 | [NAME] | Subscription | 449156.528019191 | 1110108.866951917 |  |  |  |  | Brazil & South Cone | LATAM | Superman | 0
2023-03-29 00:00:00 | Q1 | 12345678 | Pita 1246 | [NAME] | Subscription | 89832.93198080898 | 222025.7930480831 |  |  |  |  | Brazil & South Cone | LATAM | Superman | 0
2023-03-29 00:00:00 | Q1 | 12345678 | Pita 1246 | [NAME] | ILS | 76375.85 | 76375.85 |  |  |  |  | Brazil & South Cone | LATAM | Superman | 0
2023-03-29 00:00:00 | Q1 | 12345678 | Pita 1246 | [NAME] | Subscription | 71217.94362484643 | 196847.9894702088 |  |  |  |  | Brazil & South Cone | LATAM | Superman | 0
2023-03-29 00:00:00 | Q1 | 12345678 | Pita 1246 | [NAME] | Subscription | 14242.27637515356 | 39365.97052979116 |  |  |  |  | Brazil & South Cone | LATAM | Superman | 0
2023-02-12 00:00:00 | Q1 | 12345679 | Pizza 1235 | [NAME] | SW | 10282.38 | 14185.6 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Batman | 1
2023-02-12 00:00:00 | Q1 | 12345679 | Pizza 1235 | [NAME] | ILS | 4034.17 | 5565.12 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Batman | 1
2023-03-01 00:00:00 | Q1 | 12345680 | Fish 1237 | [NAME] | HW | 80170 | 80170 |  |  |  |  | ROA | APAC | Spiderman | 1
2023-03-01 00:00:00 | Q1 | 12345680 | Fish 1237 | [NAME] | Support | 131900 | 131900 |  |  |  |  | ROA | APAC | Spiderman | 1
2023-03-07 00:00:00 | Q1 | 12345681 | Shawarma 1238 | [NAME] | SW | 94500 | 105000 |  |  |  |  | NA | NA | Batman | 1
2023-03-07 00:00:00 | Q1 | 12345681 | Shawarma 1238 | [NAME] | ILS | 7650 | 8500 |  |  |  |  | NA | NA | Batman | 1
2023-04-17 00:00:00 | Q1 | 12345682 | Volvo 1109 | [NAME] | Subscription | 20452.69 | 33078.61 |  |  |  |  | ME | ME&A | Wonder woman | 1
2023-03-23 00:00:00 | Q1 | 12345683 | BMW 1123 | [NAME] | SW | 2000 | 2000 |  |  |  |  | NA | NA | Spiderman | 1
2023-03-23 00:00:00 | Q1 | 12345683 | BMW 1123 | [NAME] | Support | 561.6 | 720 |  |  |  |  | NA | NA | Spiderman | 1
2023-03-23 00:00:00 | Q1 | 12345683 | BMW 1123 | [NAME] | SW | 1700 | 1700 |  |  |  |  | NA | NA | Spiderman | 1
2023-03-23 00:00:00 | Q1 | 12345683 | BMW 1123 | [NAME] | ILS | 45566.67 | 45566.67 |  |  |  |  | NA | NA | Spiderman | 1
2023-03-23 00:00:00 | Q1 | 12345683 | BMW 1123 | [NAME] | SW | 203132.21 | 533062 |  |  |  |  | NA | NA | Spiderman | 1
2023-03-23 00:00:00 | Q1 | 12345683 | BMW 1123 | [NAME] | Support | 57039.52 | 73127.6 |  |  |  |  | NA | NA | Spiderman | 1
2023-03-25 00:00:00 | Q1 | 12345684 | Ice cream 1247 | [NAME] | Subscription | 51615.36 | 55048.22 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Wonder woman | 1
2023-03-25 00:00:00 | Q1 | 12345684 | Ice cream 1247 | [NAME] | ILS | 1471.59 | 1471.59 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Wonder woman | 1
2023-03-15 00:00:00 | Q1 | 12345685 | Hamburger 1242 | [NAME] | Subscription | 240597.37 | 240597.37 |  |  |  |  | Brazil & South Cone | LATAM | Spiderman | 0
2023-03-15 00:00:00 | Q1 | 12345685 | Hamburger 1242 | [NAME] | Subscription | 481194.74 | 481194.74 |  |  |  |  | Brazil & South Cone | LATAM | Spiderman | 0
2023-03-15 00:00:00 | Q1 | 12345685 | Hamburger 1242 | [NAME] | SW | 495797.41 | 817324.58 |  |  |  |  | Brazil & South Cone | LATAM | Spiderman | 0
2023-03-15 00:00:00 | Q1 | 12345685 | Hamburger 1242 | [NAME] | Support | 139219.91 | 178487.07 |  |  |  |  | Brazil & South Cone | LATAM | Spiderman | 0
2023-03-15 00:00:00 | Q1 | 12345685 | Hamburger 1242 | [NAME] | SW | 14661.22 | 24169.1 |  |  |  |  | Brazil & South Cone | LATAM | Spiderman | 0
2023-03-15 00:00:00 | Q1 | 12345685 | Hamburger 1242 | [NAME] | Support | 4116.87 | 5278.04 |  |  |  |  | Brazil & South Cone | LATAM | Spiderman | 0
2023-03-15 00:00:00 | Q1 | 12345685 | Hamburger 1242 | [NAME] | SW | 13014.13 | 13014.13 |  |  |  |  | Brazil & South Cone | LATAM | Spiderman | 0
2023-03-15 00:00:00 | Q1 | 12345685 | Hamburger 1242 | [NAME] | ILS | 52621.56 | 52621.56 |  |  |  |  | Brazil & South Cone | LATAM | Spiderman | 0
2023-03-21 00:00:00 | Q1 | 12345686 | KFC  1243 | [NAME] | SW | 56122.26 | 119323.5 |  |  |  |  | FSU & Central Europe | EMEA | Batman | 0
2023-03-21 00:00:00 | Q1 | 12345686 | KFC  1243 | [NAME] | Customization | 15901.31 | 33808.32 |  |  |  |  | FSU & Central Europe | EMEA | Batman | 0
2023-03-21 00:00:00 | Q1 | 12345686 | KFC  1243 | [NAME] | ILS | 27453.13 | 58369.08 |  |  |  |  | FSU & Central Europe | EMEA | Batman | 0
2023-03-21 00:00:00 | Q1 | 12345686 | KFC  1243 | [NAME] | Support | 1831321.4 | 1757079.86 |  |  |  |  | FSU & Central Europe | EMEA | Batman | 0
2023-03-21 00:00:00 | Q1 | 12345686 | KFC  1243 | [NAME] | SW | 554512.06 | 995533.28 |  |  |  |  | FSU & Central Europe | EMEA | Spiderman | 0
2023-03-21 00:00:00 | Q1 | 12345686 | KFC  1243 | [NAME] | Support | 88721.93 | 133082.89 |  |  |  |  | FSU & Central Europe | EMEA | Spiderman | 0
2023-03-21 00:00:00 | Q1 | 12345686 | KFC  1243 | [NAME] | SW | 1690.44 | 1690.44 |  |  |  |  | FSU & Central Europe | EMEA | Spiderman | 0
2023-03-21 00:00:00 | Q1 | 12345686 | KFC  1243 | [NAME] | ILS | 41995.69 | 41995.69 |  |  |  |  | FSU & Central Europe | EMEA | Spiderman | 0
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | SW | 2053408.78 | 2053408.78 |  |  |  |  | South-East Africa | EMEA | Batman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | Subscription | 213241.995 | 213241.995 |  |  |  |  | South-East Africa | EMEA | Batman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | Subscription | 213241.995 | 213241.995 |  |  |  |  | South-East Africa | EMEA | Batman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | HW | 671653.53 | 671653.53 |  |  |  |  | South-East Africa | EMEA | Batman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | ILS | 626474.1 | 626474.1 |  |  |  |  | South-East Africa | EMEA | Batman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | Support | 319919.61 | 639839.21 |  |  |  |  | South-East Africa | EMEA | Batman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | SW | 278896.65 | 464119.29 |  |  |  |  | South-East Africa | EMEA | Spiderman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | Support | 22311.73 | 44623.47 |  |  |  |  | South-East Africa | EMEA | Spiderman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | SW | 687846.38 | 1144667.15 |  |  |  |  | South-East Africa | EMEA | Spiderman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | Support | 55027.71 | 110055.43 |  |  |  |  | South-East Africa | EMEA | Spiderman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | SW | 30895.86 | 30895.86 |  |  |  |  | South-East Africa | EMEA | Spiderman | 1
2023-03-20 00:00:00 | Q1 | 12345687 | Dominos 1241 | [NAME] | ILS | 42641.67 | 42641.67 |  |  |  |  | South-East Africa | EMEA | Spiderman | 1
2023-03-27 00:00:00 | Q1 | 12345688 | [NAME] 1239 | [NAME] | SW | 168625.82 | 213656.17 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Batman | 0
2023-03-27 00:00:00 | Q1 | 12345688 | [NAME] 1239 | [NAME] | Customization | 23528.86 | 29812.74 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Batman | 0
2023-03-27 00:00:00 | Q1 | 12345688 | [NAME] 1239 | [NAME] | HW | 1386.64 | 1756.91 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Batman | 0
2023-03-27 00:00:00 | Q1 | 12345688 | [NAME] 1239 | [NAME] | ILS | 115465.6 | 146300.07 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Batman | 0
2023-03-27 00:00:00 | Q1 | 12345689 | Hut 1245 | [NAME] | SW | 54972.71 | 65273.79 |  |  |  |  | Brazil & South Cone | LATAM | Batman | 0
2023-03-27 00:00:00 | Q1 | 12345689 | Hut 1245 | [NAME] | Customization | 4315.63 | 6165.18 |  |  |  |  | Brazil & South Cone | LATAM | Batman | 0
2023-03-27 00:00:00 | Q1 | 12345689 | Hut 1245 | [NAME] | ILS | 29365.43 | 41950.62 |  |  |  |  | Brazil & South Cone | LATAM | Batman | 0
2023-04-06 00:00:00 | Q1 | 12345690 | Cheese 1138 | [NAME] | Support | 185000 | 187751.03 |  |  |  |  | FSU & Central Europe | EMEA | Spiderman | 1
2023-04-30 00:00:00 | Q1 | 12345691 | Sandwich 1035 | [NAME] | Support | 144000 | 144000 |  |  |  |  | ROCA | LATAM | Spiderman | 1
2023-04-17 00:00:00 | Q1 | 12345682 | Volvo 1109 | [NAME] | Subscription | 1021.24 | 1235.01 |  |  |  |  | ME | ME&A | Wonder woman | 1
2023-06-15 00:00:00 | Q2 | 12345693 | French fries 1198 | [NAME] | Customization | 21537.34 | 33751.17 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Batman | 1
2023-06-15 00:00:00 | Q2 | 12345693 | French fries 1198 | [NAME] | ILS | 10768.67 | 16875.58 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Batman | 1
2023-07-04 00:00:00 | Q2 | 12345694 | Schnitzel 1055 | [NAME] | Support | 132000 | 134834.3 |  |  |  |  | North-West Africa | EMEA | Spiderman | 0
2023-06-21 00:00:00 | Q2 | 12345695 | Kabab 1096 | [NAME] | Support | 430000 | 474792 |  |  |  |  | South-East Africa | EMEA | Batman | 1
2023-07-26 00:00:00 | Q2 | 12345696 | [NAME] | [NAME] | Support | 99000 | 109281.92 |  |  |  |  | MEXICO | LATAM | Spiderman | 0
2023-07-26 00:00:00 | Q2 | 12345697 | Pasta 1095 | [NAME] | Support | 264649.42 | 286414.23 |  |  |  |  | Nordics & South Europe & West Europe | EMEA | Batman | 0
2023-07-31 00:00:00 | Q2 | 12345698 | [NAME] 1034 | [NAME] | Subscription | 354999.9999999999 | 486872.85 |  |  |  |  | Great India | APAC | Superman | 0
2023-07-31 00:00:00 | Q2 | 12345699 | Swatch 1112 | [NAME] | Support | 28682.4 | 28682.4 |  |  |  |  | South-East Africa | EMEA | Batman | 1