Spreadsheet: 135083d1325802051-allocating-customer-numbers-to-different-companies-sums-ef3a_excelhelp-example
Sheet: Sheet1

 | Fig.1 |  |  |  | Fig.2 |  |  |  |  | Fig.3 |  |  | MATCH?
 | Customer 1 | 60 |  |  | Company A | 50 |  |  |  | Company A | Customer 1 | 50
 | Customer 2 | 8 |  |  | Company B | 100 |  |  |  |  | TOTAL: | 50 | 1
 | Customer 3 | 5 |  |  | Company C | 90
 | Customer 4 | 110 |  |  | Company D | 60 |  |  |  | Company B | Customer 1 | 10
 | Customer 5 | 70 |  |  | TOTAL: | 300 |  |  |  |  | Customer 2 | 8
 | Customer 6 | 28 |  |  |  |  |  |  |  |  | Customer 3 | 5
 | Customer 7 | 1 |  |  |  |  |  |  |  |  | Customer 4 | 77
 | Customer 8 | 18 |  |  |  |  |  |  |  |  | TOTAL: | 100 | 1
 | TOTAL: | 300
 |  |  |  |  |  |  |  |  |  | Company C | Customer 4 | 33
 |  |  |  |  |  |  |  |  |  |  | Customer 5 | 57
 |  |  |  |  |  |  |  |  |  |  | TOTAL: | 90 | 1
 |  |  |  |  |  |  |  |  |  | Company D | Customer 5 | 13
 |  |  |  |  |  |  |  |  |  |  | Customer 6 | 28
 |  |  |  |  |  |  |  |  |  |  | Customer 7 | 1
 |  |  |  |  |  |  |  |  |  |  | Customer 8 | 18
 |  |  |  |  |  |  |  |  |  |  | TOTAL: | 60 | 1
 |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL: | 300 | 1
 |  |  |  | Company A | Company B | Company C | Company D
 |  |  |  | 50 | 100 | 90 | 60
 | Customer 1 | 60 |  | 50 | 10 | 0 | 0 |  | 60
 | Customer 2 | 8 |  | 0 | 8 | 0 | 0 |  | 8
 | Customer 3 | 5 |  | 0 | 5 | 0 | 0 |  | 5
 | Customer 4 | 110 |  | 0 | 77 | 33 | 0 |  | 110
 | Customer 5 | 70 |  | 0 | 0 | 57 | 13 |  | 70
 | Customer 6 | 28 |  | 0 | 0 | 0 | 28 |  | 28
 | Customer 7 | 1 |  | 0 | 0 | 0 | 1 |  | 1
 | Customer 8 | 18 |  | 0 | 0 | 0 | 18 |  | 18
 |  |  |  | 50 | 100 | 90 | 60
 |  |  |  |  |  |  |  |  |  | FILTER for
Company A |  |  |  |  |  |  |  |  |  | < > 0
 | Customer 1 | 50 |  |  |  |  |  |  |  | 50
 | Customer 2 | 0 |  |  |  |  |  |  |  | 0
 | Customer 3 | 0 |  |  |  |  |  |  |  | 0
 | Customer 4 | 0 |  |  |  |  |  |  |  | 0
 | Customer 5 | 0 |  |  |  |  |  |  |  | 0
 | Customer 6 | 0 |  |  |  |  |  |  |  | 0
 | Customer 7 | 0 |  |  |  |  |  |  |  | 0
 | Customer 8 | 0 |  |  |  |  |  |  |  | 0
 | TOTALS: | 50
Company B
 | Customer 1 | 10 |  |  |  |  |  |  |  | 10
 | Customer 2 | 8 |  |  |  |  |  |  |  | 8
 | Customer 3 | 5 |  |  |  |  |  |  |  | 5
 | Customer 4 | 77 |  |  |  |  |  |  |  | 77
 | Customer 5 | 0 |  |  |  |  |  |  |  | 0
 | Customer 6 | 0 |  |  |  |  |  |  |  | 0
 | Customer 7 | 0 |  |  |  |  |  |  |  | 0
 | Customer 8 | 0 |  |  |  |  |  |  |  | 0
 | TOTALS: | 100
Company C
 | Customer 1 | 0 |  |  |  |  |  |  |  | 0
 | Customer 2 | 0 |  |  |  |  |  |  |  | 0
 | Customer 3 | 0 |  |  |  |  |  |  |  | 0
 | Customer 4 | 33 |  |  |  |  |  |  |  | 33
 | Customer 5 | 57 |  |  |  |  |  |  |  | 57
 | Customer 6 | 0 |  |  |  |  |  |  |  | 0
 | Customer 7 | 0 |  |  |  |  |  |  |  | 0
 | Customer 8 | 0 |  |  |  |  |  |  |  | 0
 | TOTALS: | 90
Company D
 | Customer 1 | 0 |  |  |  |  |  |  |  | 0
 | Customer 2 | 0 |  |  |  |  |  |  |  | 0
 | Customer 3 | 0 |  |  |  |  |  |  |  | 0
 | Customer 4 | 0 |  |  |  |  |  |  |  | 0
 | Customer 5 | 13 |  |  |  |  |  |  |  | 13
 | Customer 6 | 28 |  |  |  |  |  |  |  | 28
 | Customer 7 | 1 |  |  |  |  |  |  |  | 1
 | Customer 8 | 18 |  |  |  |  |  |  |  | 18
 | TOTALS: | 60