Spreadsheet: 100557d1298908877-sumifs-on-multiple-work-sheets-2011-master-order-worksheet
Sheet: Master

Order # | PO # | Terms | Customer | Style | Description | Color | Size | Total Units | Balance | Start Ship | Cost | Total Dollars | NOTES
 |  |  |  | 510 | SHEEPSKIN CARE KIT (CASE OF 6) | NA | NA | 6 |  |  | 60
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 5 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 6 | 4 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 7 | 5 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 8 | 4 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 9 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | BLK | 10 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 5 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 6 | 6 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 7 | 8 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 8 | 6 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 9 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHE | 10 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHO | 5 | 0 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHO | 6 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHO | 7 | 4 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHO | 8 | 6 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHO | 9 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | CHO | 10 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 5 | 0 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 6 | 1 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 7 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 8 | 2 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 9 | 1 |  |  | 100
 |  |  |  | 1873 | W BAILEY BUTTON TRIPLET | GRY | 10 | 1 |  |  | 100
 |  |  |  | 1891 | W GREENFIELD | CHE | 6 | 1 |  |  | 110
 |  |  |  | 1891 | W GREENFIELD | CHE | 7 | 2 |  |  | 110
 |  |  |  | 1891 | W GREENFIELD | CHE | 8 | 1 |  |  | 110
 |  |  |  | 1891 | W GREENFIELD | CHE | 9 | 1 |  |  | 110
 |  |  |  | 3010 | M KENTON | CHE | 8 | 1 |  |  | 50
 |  |  |  | 3010 | M KENTON | CHE | 9 | 2 |  |  | 50
 |  |  |  | 3010 | M KENTON | CHE | 10 | 1 |  |  | 50
 |  |  |  | 3010 | M KENTON | CHE | 11 | 1 |  |  | 50
 |  |  |  | 3010 | M KENTON | CHE | 12 | 1 |  |  | 50
 |  |  |  | 5614 | W COZY II | CHE | 5 | 1 |  |  | 45
 |  |  |  | 5614 | W COZY II | CHE | 6 | 1 |  |  | 45
 |  |  |  | 5614 | W COZY II | CHE | 7 | 2 |  |  | 45
 |  |  |  | 5614 | W COZY II | CHE | 8 | 2 |  |  | 45
 |  |  |  | 5614 | W COZY II | CHE | 9 | 1 |  |  | 45
 |  |  |  | 5614 | W COZY II | CHE | 10 | 0 |  |  | 45
 |  |  |  | 5678 | W KENSINGTON | BLK | 5 | 0 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 6 | 1 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 7 | 2 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 8 | 2 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 9 | 1 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | BLK | 10 | 1 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 5 | 0 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 6 | 1 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 7 | 2 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 8 | 2 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 9 | 1 |  |  | 110
 |  |  |  | 5678 | W KENSINGTON | TOAS | 10 | 1 |  |  | 110
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 5 | 0 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 6 | 2 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 7 | 2 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 8 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 9 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | BLK | 10 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 5 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 6 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 7 | 2 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 8 | 2 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 9 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHE | 10 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHO | 5 | 0 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHO | 6 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHO | 7 | 2 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHO | 8 | 2 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHO | 9 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | CHO | 10 | 0 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 5 | 0 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 6 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 7 | 2 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 8 | 2 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 9 | 1 |  |  | 80
 |  |  |  | 5803 | W BAILEY BUTTON | GRY | 10 | 0 |  |  | 80
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 5 | 1 |  |  | 100
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 6 | 2 |  |  | 100
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 7 | 2 |  |  | 100
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 8 | 1 |  |  | 100
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 9 | 0 |  |  | 100
 |  |  |  | 5804 | W CLASSIC TALL BOMBER | BJCE | 10 | 0 |  |  | 100
 |  |  |  | 5815 | W CLASSIC TALL | BLK | 5 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | BLK | 6 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | BLK | 7 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | BLK | 8 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | BLK | 9 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | BLK | 10 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 5 | 4 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 6 | 12 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 7 | 24 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 8 | 18 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 9 | 6 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHE | 10 | 2 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHO | 5 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHO | 6 | 2 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHO | 7 | 8 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHO | 8 | 2 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHO | 9 | 2 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | CHO | 10 | 2 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | GRY | 5 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | GRY | 6 | 4 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | GRY | 7 | 2 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | GRY | 8 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | GRY | 9 | 1 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | GRY | 10 | 1 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 5 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 6 | 0 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 7 | 2 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 8 | 2 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 9 | 1 |  |  | 90
 |  |  |  | 5815 | W CLASSIC TALL | SND | 10 | 0 |  |  | 90
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 5 | 0 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 6 | 2 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 7 | 4 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 8 | 2 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 9 | 2 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | BLK | 10 | 1 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 5 | 1 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 6 | 2 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 7 | 4 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 8 | 1 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 9 | 1 |  |  | 70
 |  |  |  | 5819 | W CLASSIC CARDY | GRY | 10 | 0 |  |  | 70
 |  |  |  | 5825 | W CLASSIC SHORT | BLK | 5 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | BLK | 6 | 2 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | BLK | 7 | 2 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | BLK | 8 | 2 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | BLK | 9 | 1 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | BLK | 10 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHE | 5 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHE | 6 | 8 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHE | 7 | 6 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHE | 8 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHE | 9 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHE | 10 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHO | 5 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHO | 6 | 2 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHO | 7 | 2 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHO | 8 | 2 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHO | 9 | 1 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | CHO | 10 | 1 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | GRY | 5 | 2 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | GRY | 6 | 2 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | GRY | 7 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | GRY | 8 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | GRY | 9 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | GRY | 10 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | SND | 5 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | SND | 6 | 2 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | SND | 7 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | SND | 8 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | SND | 9 | 0 |  |  | 75
 |  |  |  | 5825 | W CLASSIC SHORT | SND | 10 | 0 |  |  | 75
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 5 | 0 |  |  | 60
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 6 | 2 |  |  | 60
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 7 | 1 |  |  | 60
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 8 | 1 |  |  | 60
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 9 | 0 |  |  | 60
 |  |  |  | 5854 | W CLASSIC MINI | CHE | 10 | 0 |  |  | 60
 |  |  |  | 9698 | CLEANER AND CONDITIONER, WOMENS (CASE OF 12) | NA | NA | 2 |  |  | 48
 |  |  |  | 9701 | STAIN AND WATER REPELLENT, WOMENS (CASE OF 12) | NA | NA | 2 |  |  | 48
 |  |  |  |  | TOTAL