Spreadsheet: 732526d1621004793-sumproduct-using-filters-test2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | HIDE
 |  |  |  |  |  |  |  |  |  |  | ME
Customer | 2021-06 | 2021-07 | 2021-08 | 2021-09 | 2021-10 | 2021-11 | 2021-12 | 2022-01 | 2022-02 | 2022-03 | Helper
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer A | 125364.2358960697 | 200410.7494464966 | 150381.9586022579 | 175471.6459451735 | 165628.5658007894 | 170636.4306998273 | 220420.717842798 | 150364.2015483463 | 100355.340865058 | 125327.9151776058
Customer C | 427606.9942672258 | 502753.1797114249 | 432662.6942009606 | 402944.5687072664 | 503437.7453963452 | 653462.4636504641 | 702784.5089569434 | 502606.8863172385 | 477579.038455475 | 452492.843437768
Customer C | 427606.9942672258 | 502753.1797114249 | 432662.6942009606 | 402944.5687072664 | 503437.7453963452 | 653462.4636504641 | 702784.5089569434 | 502606.8863172385 | 477579.038455475 | 452492.843437768
Customer C | 427606.9942672258 | 502753.1797114249 | 432662.6942009606 | 402944.5687072664 | 503437.7453963452 | 653462.4636504641 | 702784.5089569434 | 502606.8863172385 | 477579.038455475 | 452492.843437768
Customer C | 427606.9942672258 | 502753.1797114249 | 432662.6942009606 | 402944.5687072664 | 503437.7453963452 | 653462.4636504641 | 702784.5089569434 | 502606.8863172385 | 477579.038455475 | 452492.843437768
Customer C | 427606.9942672258 | 502753.1797114249 | 432662.6942009606 | 402944.5687072664 | 503437.7453963452 | 653462.4636504641 | 702784.5089569434 | 502606.8863172385 | 477579.038455475 | 452492.843437768
Customer C | 427606.9942672258 | 502753.1797114249 | 432662.6942009606 | 402944.5687072664 | 503437.7453963452 | 653462.4636504641 | 702784.5089569434 | 502606.8863172385 | 477579.038455475 | 452492.843437768
Customer C | 427606.9942672258 | 502753.1797114249 | 432662.6942009606 | 402944.5687072664 | 503437.7453963452 | 653462.4636504641 | 702784.5089569434 | 502606.8863172385 | 477579.038455475 | 452492.843437768
Customer C | 427606.9942672258 | 502753.1797114249 | 432662.6942009606 | 402944.5687072664 | 503437.7453963452 | 653462.4636504641 | 702784.5089569434 | 502606.8863172385 | 477579.038455475 | 452492.843437768
Customer E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Customer F | 250620.4773216066 | 250699.713342819 | 250650.6680232534 | 200803.4507745273 | 201070.764383016 | 201084.1622703257 | 200716.6945462219 | 250620.418810121 | 450605.3246003145 | 300558.604830854
Customer F | 250620.4773216066 | 250699.713342819 | 250650.6680232534 | 200803.4507745273 | 201070.764383016 | 201084.1622703257 | 200716.6945462219 | 250620.418810121 | 450605.3246003145 | 300558.604830854
Customer G | 151190.5917619306 | 125521.6655256036 | 300485.1001911389 | 150599.0061142779 | 150798.2995756709 | 250808.2882603189 | 350534.3257220819 | 200462.5481391739 | 150451.2947752456 | 200416.4632355275
Customer F | 250620.4773216066 | 250699.713342819 | 250650.6680232534 | 200803.4507745273 | 201070.764383016 | 201084.1622703257 | 200716.6945462219 | 250620.418810121 | 450605.3246003145 | 300558.604830854
Customer G | 151190.5917619306 | 125521.6655256036 | 300485.1001911389 | 150599.0061142779 | 150798.2995756709 | 250808.2882603189 | 350534.3257220819 | 200462.5481391739 | 150451.2947752456 | 200416.4632355275
Customer G | 151190.5917619306 | 125521.6655256036 | 300485.1001911389 | 150599.0061142779 | 150798.2995756709 | 250808.2882603189 | 350534.3257220819 | 200462.5481391739 | 150451.2947752456 | 200416.4632355275
Customer G | 151190.5917619306 | 125521.6655256036 | 300485.1001911389 | 150599.0061142779 | 150798.2995756709 | 250808.2882603189 | 350534.3257220819 | 200462.5481391739 | 150451.2947752456 | 200416.4632355275
Customer F | 250620.4773216066 | 250699.713342819 | 250650.6680232534 | 200803.4507745273 | 201070.764383016 | 201084.1622703257 | 200716.6945462219 | 250620.418810121 | 450605.3246003145 | 300558.604830854
Customer D | 74864.94154012416 | 81994.77989486205 | 60134.16681981065 | 50165.67040555295 | 60220.79009095519 | 50223.5527162392 | 50147.78139482163 | 50127.92947513914 | 25124.81707057196 | 50115.18352064054
Customer D | 74864.94154012416 | 81994.77989486205 | 60134.16681981065 | 50165.67040555295 | 60220.79009095519 | 50223.5527162392 | 50147.78139482163 | 50127.92947513914 | 25124.81707057196 | 50115.18352064054
Customer D | 74864.94154012416 | 81994.77989486205 | 60134.16681981065 | 50165.67040555295 | 60220.79009095519 | 50223.5527162392 | 50147.78139482163 | 50127.92947513914 | 25124.81707057196 | 50115.18352064054
Customer D | 74864.94154012416 | 81994.77989486205 | 60134.16681981065 | 50165.67040555295 | 60220.79009095519 | 50223.5527162392 | 50147.78139482163 | 50127.92947513914 | 25124.81707057196 | 50115.18352064054
Customer D | 74864.94154012416 | 81994.77989486205 | 60134.16681981065 | 50165.67040555295 | 60220.79009095519 | 50223.5527162392 | 50147.78139482163 | 50127.92947513914 | 25124.81707057196 | 50115.18352064054
Customer G | 151190.5917619306 | 125521.6655256036 | 300485.1001911389 | 150599.0061142779 | 150798.2995756709 | 250808.2882603189 | 350534.3257220819 | 200462.5481391739 | 150451.2947752456 | 200416.4632355275
Customer G | 151190.5917619306 | 125521.6655256036 | 300485.1001911389 | 150599.0061142779 | 150798.2995756709 | 250808.2882603189 | 350534.3257220819 | 200462.5481391739 | 150451.2947752456 | 200416.4632355275
Customer D | 74864.94154012416 | 81994.77989486205 | 60134.16681981065 | 50165.67040555295 | 60220.79009095519 | 50223.5527162392 | 50147.78139482163 | 50127.92947513914 | 25124.81707057196 | 50115.18352064054
Customer D | 74864.94154012416 | 81994.77989486205 | 60134.16681981065 | 50165.67040555295 | 60220.79009095519 | 50223.5527162392 | 50147.78139482163 | 50127.92947513914 | 25124.81707057196 | 50115.18352064054
Customer G | 151190.5917619306 | 125521.6655256036 | 300485.1001911389 | 150599.0061142779 | 150798.2995756709 | 250808.2882603189 | 350534.3257220819 | 200462.5481391739 | 150451.2947752456 | 200416.4632355275
Customer D | 74864.94154012416 | 81994.77989486205 | 60134.16681981065 | 50165.67040555295 | 60220.79009095519 | 50223.5527162392 | 50147.78139482163 | 50127.92947513914 | 25124.81707057196 | 50115.18352064054
Customer G | 151190.5917619306 | 125521.6655256036 | 300485.1001911389 | 150599.0061142779 | 150798.2995756709 | 250808.2882603189 | 350534.3257220819 | 200462.5481391739 | 150451.2947752456 | 200416.4632355275
Customer G | 151190.5917619306 | 125521.6655256036 | 300485.1001911389 | 150599.0061142779 | 150798.2995756709 | 250808.2882603189 | 350534.3257220819 | 200462.5481391739 | 150451.2947752456 | 200416.4632355275
Customer G | 151190.5917619306 | 125521.6655256036 | 300485.1001911389 | 150599.0061142779 | 150798.2995756709 | 250808.2882603189 | 350534.3257220819 | 200462.5481391739 | 150451.2947752456 | 200416.4632355275
Customer D | 74864.94154012416 | 81994.77989486205 | 60134.16681981065 | 50165.67040555295 | 60220.79009095519 | 50223.5527162392 | 50147.78139482163 | 50127.92947513914 | 25124.81707057196 | 50115.18352064054
Customer F | 250620.4773216066 | 250699.713342819 | 250650.6680232534 | 200803.4507745273 | 201070.764383016 | 201084.1622703257 | 200716.6945462219 | 250620.418810121 | 450605.3246003145 | 300558.604830854
Customer F | 250620.4773216066 | 250699.713342819 | 250650.6680232534 | 200803.4507745273 | 201070.764383016 | 201084.1622703257 | 200716.6945462219 | 250620.418810121 | 450605.3246003145 | 300558.604830854
Customer F | 250620.4773216066 | 250699.713342819 | 250650.6680232534 | 200803.4507745273 | 201070.764383016 | 201084.1622703257 | 200716.6945462219 | 250620.418810121 | 450605.3246003145 | 300558.604830854
Customer F | 250620.4773216066 | 250699.713342819 | 250650.6680232534 | 200803.4507745273 | 201070.764383016 | 201084.1622703257 | 200716.6945462219 | 250620.418810121 | 450605.3246003145 | 300558.604830854
Customer F | 250620.4773216066 | 250699.713342819 | 250650.6680232534 | 200803.4507745273 | 201070.764383016 | 201084.1622703257 | 200716.6945462219 | 250620.418810121 | 450605.3246003145 | 300558.604830854
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157
Customer B | 251359.9146768842 | 251431.1267972143 | 251387.0480922883 | 191524.3591725471 | 201764.6030485303 | 251776.6441877583 | 251446.3883850827 | 201359.8620906123 | 251346.2964083811 | 251304.3077548157