Spreadsheet: 121436d1316054299-multiple-countifs-help-sample_multiple_countif
Sheet: Count - Invoice

 |  |  |  |  | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2008 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011
COUNTRY | NAME | BRANCHID | Invoice_Type | CATEGORY | P01_2008 | P02_2008 | P03_2008 | P04_2008 | P05_2008 | P06_2008 | P07_2008 | P08_2008 | P09_2008 | P10_2008 | P11_2008 | P12_2008 | P01_2009 | P02_2009 | P03_2009 | P04_2009 | P05_2009 | P06_2009 | P07_2009 | P08_2009 | P09_2009 | P10_2009 | P11_2009 | P12_2009 | P01_2010 | P02_2010 | P03_2010 | [NAME] | P05_2010 | P06_2010 | P07_2010 | P08_2010 | P09_2010 | P10_2010 | P11_2010 | [NAME] | P01_2011 | P02_2011 | P03_2011 | P04_2011 | P05_2011 | P06_2011 | P07_2011 | P08_2011
US | Chicago | 021 |  |  | 51 | 49 | 55 | 53
US | Chicago | 021 |  | RECYCLIN | 21 | 13 | 4 | 16 | 17 | 16 | 31 | 12 | 1 |  | 1
US | Chicago | 021 | Auto | AUTOMATI | 1588 | 1328 | 1347 | 1658 | 1396 | 1382 | 1788 | 1461 | 1414 | 1749 | 1370 | 1631 | 1510 | 1462 | 1504 | 1835 | 1472 | 1474 | 1853 | 1496 | 1497 | 1963 | 1497 | 1921 | 1643 | 1605 | 1582 | 2012 | 1573 | 1354 | 1875 | 1465 | 1499 | 1905 | 1512 | 1872 | 1642 | 1501 | 1595 | 2077 | 1692 | 1499 | 2016 | 1811
US | Chicago | 021 | Auto Offsite | OFF-SITE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 6 | 4 | 9 | 4 | 10 | 10 | 12 | 6 | 13 | 15 | 5 | 14 | 18 | 23 | 13 | 8 | 17 | 9 | 2 | 3 | 47 | 3
US | Chicago | 21 | Delivery | DELIVERY | 60 | 52 | 39 | 70 | 80 | 56 | 61 | 46 | 46 | 68 | 49 | 46 | 64 | 70 | 75 | 70 | 35 | 62 | 60 | 118 | 42 | 75 | 51 | 61 | 49 | 68 | 73 | 67 | 64 | 63 | 91 | 58 | 68 | 98 | 62 | 66 | 68 | 37 | 51 | 73 | 48 | 57 | 64 | 72
US | Chicago | 021 | Pickup | PICKUP | 37 | 10 | 24 | 19 | 19 | 29 | 24 | 32 | 27 | 38 | 26 | 13 | 25 | 29 | 18 | 36 | 14 | 21 | 32 | 23 | 23 | 43 | 22 | 22 | 26 | 25 | 35 | 68 | 117 | 43 | 44 | 20 | 31 | 38 | 26 | 33 | 30 | 22 | 26 | 40 | 27 | 28 | 79 | 33
US | Chicago | 021 | Purge | CALL-IN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
US | Chicago | 021 | Purge | [NAME] | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
US | Chicago | 021 | Purge | OTHER |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 3 |  |  |  |  | 1 |  |  |  |  |  |  | 1
US | Chicago | 021 | Purge | PURGE | 214 | 148 | 195 | 198 | 147 | 193 | 184 | 172 | 147 | 186 | 141 | 121 | 182 | 189 | 192 | 254 | 186 | 176 | 215 | 233 | 151 | 191 | 140 | 153 | 149 | 166 | 157 | 181 | 127 | 169 | 191 | 183 | 134 | 193 | 128 | 152 | 163 | 116 | 159 | 231 | 179 | 170 | 217 | 209
US | Chicago | 021 | Purge | PURGEOND |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 4 | 1 |  |  |  | 1 | 1
US | Chicago | 021 | Purge | X-SHRED | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | 36 | 38 | 60 | 41 | 32 | 15 | 33 | 30 | 38 | 8 | 26 | 44 | 14 | 3 | 1 |  |  |  |  |  |  |  | 1 | 1 | 7 | 25 | 39
US | Chicago | 021 | [NAME] | POONDEMA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 14 | 29 | 12 |  |  | 2 |  |  |  | 2 | 11 | 19 | 6
US | Milwaukee | 077 |  | RECYCLIN | 23 | 25 | 48 | 75 | 49 | 69 | 53 | 53 | 46 |  | 2
US | Milwaukee | 077 | Auto | AUTOMATI | 880 | 697 | 751 | 912 | 712 | 689 | 893 | 709 | 717 | 909 | 627 | 838 | 813 | 796 | 809 | 1015 | 737 | 769 | 954 | 792 | 786 | 981 | 775 | 972 | 886 | 826 | 848 | 1012 | 773 | 796 | 1001 | 809 | 801 | 1013 | 745 | 903 | 869 | 772 | 829 | 1012 | 742 | 758 | 894 | 755
US | Milwaukee | 077 | Auto Offsite | OFF-SITE |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
US | Milwaukee | 077 | Delivery | DELIVERY |  |  |  |  |  | 2 |  |  |  | 4 | 2 | 2 | 34 | 6 | 15 | 29 | 14 | 10 | 5 | 4 | 1 | 1 | 3 | 11 | 3 |  | 3 | 5 | 1 | 14 | 3 | 1 | 6 | 9 | 19 | 3 | 8 | 10 | 9 | 7 | 9 | 11 | 7 | 17
US | Milwaukee | 077 | Pickup | PICKUP |  |  |  |  |  | 1 |  |  |  | 1 |  | 2 | 6 | 2 | 2 | 6 | 3 | 3 | 1 | 2 | 2 | 3 | 8 | 2 | 1 | 3 | 1 | 2 | 3 | 4 |  |  | 2 | 6 | 9 | 3 | 4 | 9 | 5 | 10 | 19 | 2 | 7 | 9
US | Milwaukee | 077 | Purge | CALL-IN | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 1 |  |  |  |  | 3 | 1 |  | 4 | 25 | 8 | 11 | 6 | 12 |  | 8 | 6 | 6 | 9 | 12 | 20 | 14 | 20 | 12 | 7 | 9 | 15 | 3
US | Milwaukee | 077 | Purge | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
US | Milwaukee | 077 | Purge | OTHER |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 2 |  |  |  |  |  |  | 1
US | Milwaukee | 077 | Purge | PURGE | 76 | 75 | 79 | 88 | 62 | 82 | 60 | 76 | 54 | 120 | 129 | 125 | 144 | 132 | 113 | 164 | 85 | 124 | 123 | 106 | 70 | 77 | 67 | 45 | 78 | 63 | 83 | 110 | 45 | 53 | 81 | 63 | 46 | 51 | 34 | 42 | 46 | 45 | 65 | 80 | 53 | 33 | 60 | 72
US | Milwaukee | 077 | Purge | X-SHRED | 5 | 1 |  |  |  |  |  |  | 2 |  |  | 1 | 1 | 10 | 10 | 20 | 3 | 7 | 4 | 8 |  | 19 | 5 | 4 | 37 | 11 | 2 | 4 | 14 | 3 | 2 | 5 | 1 | 13 | 5 | 2 | 6 | 2 | 3 | 5 | 10 | 2 | 4 | 2