Spreadsheet: 112153d1308296748-excel-2007-countif-column-a-and-add-totals-in-column-b-countif-and-add-for-excel-forum
Sheet: Sheet1

STATES | STORES | PERMIT |  |  |  |  |  |  |  |  |  | STATES | STORES | PERMIT
FLORIDA | CONVENIENCE STORE | B | >10 | 205 |  |  |  |  |  |  |  | FLORIDA | CONVENIENCE STORE | B | >10 | 205
FLORIDA | CONVENIENCE STORE | B | <10 | 68 |  |  |  |  |  |  |  | FLORIDA | CONVENIENCE STORE | B | <10 | 68
FLORIDA | GAS  CONVENIENCE STORE | B | >10 | 54 |  |  |  |  |  |  |  | TEXAS | CONVENIENCE STORE | W | >10 | 340
FLORIDA | GAS  CONVENIENCE STORE | B | <10 | 254 |  |  |  |  |  |  |  | TEXAS | CONVENIENCE STORE | W | <10 | 102
FLORIDA | SUPERMARKET | B | <10 | 15 |  |  |  |  |  |  |  | ALABAMA | CONVENIENCE STORE | WB | >10 | 575
FLORIDA | UN CLASIFIED | B | <10 | 971 |  |  |  |  |  |  |  | FLORIDA | CONVENIENCE STORE | WB | >10 | 5227
TEXAS | CONVENIENCE STORE | W | >10 | 340 |  |  |  |  |  |  |  | NORTH CAROLINA | CONVENIENCE STORE | WB | >10 | 1852
TEXAS | CONVENIENCE STORE | W | <10 | 102 |  |  |  |  |  |  |  | OREGON | CONVENIENCE STORE | WB | >10 | 326
TEXAS | GAS  CONVENIENCE STORE | W | >10 | 34 |  |  |  |  |  |  |  | TEXAS | CONVENIENCE STORE | WB | >10 | 1349
TEXAS | GAS  CONVENIENCE STORE | W | <10 | 246 |  |  |  |  |  |  |  | TEXAS | CONVENIENCE STORE | WB | >10 | 2759
TEXAS | LIQUOR STORE | W | <10 | 8 |  |  |  |  |  |  |  | VERGINIA | CONVENIENCE STORE | WB | >10 | 1831
TEXAS | SUPERMARKET | W | >10 | 336 |  |  |  |  |  |  |  | VERGINIA | CONVENIENCE STORE | WB | >10 | 3349
TEXAS | SUPERMARKET | W | <10 | 17 |  |  |  |  |  |  |  | [NAME] | CONVENIENCE STORE | WB | >10 | 71
MARYLAND | UN CLASIFIED | W | >10 | 14 |  |  |  |  |  |  |  | WASHINGTON | CONVENIENCE STORE | WB | >10 | 657
MARYLAND | UN CLASIFIED | W | <10 | 14 |  |  |  |  |  |  |  | ALABAMA | CONVENIENCE STORE | WB | <10 | 296
TEXAS | UN CLASIFIED | W | <10 | 2046 |  |  |  |  |  |  |  | DIST OF COLUMBIA | CONVENIENCE STORE | WB | <10 | 3
ALABAMA | CONVENIENCE STORE | WB | >10 | 575 |  |  |  |  |  |  |  | FLORIDA | CONVENIENCE STORE | WB | <10 | 2071
FLORIDA | CONVENIENCE STORE | WB | >10 | 5227 |  |  |  |  |  |  |  | NORTH CAROLINA | CONVENIENCE STORE | WB | <10 | 758
NORTH CAROLINA | CONVENIENCE STORE | WB | >10 | 1852 |  |  |  |  |  |  |  | OREGON | CONVENIENCE STORE | WB | <10 | 42
OREGON | CONVENIENCE STORE | WB | >10 | 326 |  |  |  |  |  |  |  | TEXAS | CONVENIENCE STORE | WB | <10 | 34
TEXAS | CONVENIENCE STORE | WB | >10 | 1349 |  |  |  |  |  |  |  | TEXAS | CONVENIENCE STORE | WB | <10 | 215
TEXAS | CONVENIENCE STORE | WB | >10 | 2759 |  |  |  |  |  |  |  | [NAME] | CONVENIENCE STORE | WB | <10 | 67
VERGINIA | CONVENIENCE STORE | WB | >10 | 1831 |  |  |  |  |  |  |  | WASHINGTON | CONVENIENCE STORE | WB | <10 | 479
VERGINIA | CONVENIENCE STORE | WB | >10 | 3349 |  |  |  |  |  |  |  | FLORIDA | CONVENIENCE STORE | WBL | >10 | 152
[NAME] | CONVENIENCE STORE | WB | >10 | 71 |  |  |  |  |  |  |  | TEXAS | CONVENIENCE STORE | WBL | >10 | 205
WASHINGTON | CONVENIENCE STORE | WB | >10 | 657 |  |  |  |  |  |  |  | FLORIDA | CONVENIENCE STORE | WBL | <10 | 12
ALABAMA | CONVENIENCE STORE | WB | <10 | 296 |  |  |  |  |  |  |  | MARYLAND | CONVENIENCE STORE | WBL | <10 | 15
DIST OF COLUMBIA | CONVENIENCE STORE | WB | <10 | 3 |  |  |  |  |  |  |  | TEXAS | CONVENIENCE STORE | WBL | <10 | 25
FLORIDA | CONVENIENCE STORE | WB | <10 | 2071 |  |  |  |  |  |  |  | FLORIDA | GAS  CONVENIENCE STORE | B | >10 | 54
NORTH CAROLINA | CONVENIENCE STORE | WB | <10 | 758 |  |  |  |  |  |  |  | FLORIDA | GAS  CONVENIENCE STORE | B | <10 | 254
OREGON | CONVENIENCE STORE | WB | <10 | 42 |  |  |  |  |  |  |  | TEXAS | GAS  CONVENIENCE STORE | W | >10 | 34
TEXAS | CONVENIENCE STORE | WB | <10 | 34 |  |  |  |  |  |  |  | TEXAS | GAS  CONVENIENCE STORE | W | <10 | 246
TEXAS | CONVENIENCE STORE | WB | <10 | 215 |  |  |  |  |  |  |  | ALABAMA | GAS  CONVENIENCE STORE | WB | >10 | 125
[NAME] | CONVENIENCE STORE | WB | <10 | 67 |  |  |  |  |  |  |  | NORTH CAROLINA | GAS  CONVENIENCE STORE | WB | >10 | 654
WASHINGTON | CONVENIENCE STORE | WB | <10 | 479 |  |  |  |  |  |  |  | OREGON | GAS  CONVENIENCE STORE | WB | >10 | 39
ALABAMA | GAS  CONVENIENCE STORE | WB | >10 | 125 |  |  |  |  |  |  |  | TEXAS | GAS  CONVENIENCE STORE | WB | >10 | 1451
NORTH CAROLINA | GAS  CONVENIENCE STORE | WB | >10 | 654 |  |  |  |  |  |  |  | VERGINIA | GAS  CONVENIENCE STORE | WB | >10 | 19
OREGON | GAS  CONVENIENCE STORE | WB | >10 | 39 |  |  |  |  |  |  |  | [NAME] | GAS  CONVENIENCE STORE | WB | >10 | 33
TEXAS | GAS  CONVENIENCE STORE | WB | >10 | 1451 |  |  |  |  |  |  |  | WASHINGTON | GAS  CONVENIENCE STORE | WB | >10 | 156
VERGINIA | GAS  CONVENIENCE STORE | WB | >10 | 19 |  |  |  |  |  |  |  | ALABAMA | GAS  CONVENIENCE STORE | WB | <10 | 687
[NAME] | GAS  CONVENIENCE STORE | WB | >10 | 33 |  |  |  |  |  |  |  | DIST OF COLUMBIA | GAS  CONVENIENCE STORE | WB | <10 | 1
WASHINGTON | GAS  CONVENIENCE STORE | WB | >10 | 156 |  |  |  |  |  |  |  | MARYLAND | GAS  CONVENIENCE STORE | WB | <10 | 14
ALABAMA | GAS  CONVENIENCE STORE | WB | <10 | 687 |  |  |  |  |  |  |  | NORTH CAROLINA | GAS  CONVENIENCE STORE | WB | <10 | 722
DIST OF COLUMBIA | GAS  CONVENIENCE STORE | WB | <10 | 1 |  |  |  |  |  |  |  | OREGON | GAS  CONVENIENCE STORE | WB | <10 | 209
MARYLAND | GAS  CONVENIENCE STORE | WB | <10 | 14 |  |  |  |  |  |  |  | TEXAS | GAS  CONVENIENCE STORE | WB | <10 | 832
NORTH CAROLINA | GAS  CONVENIENCE STORE | WB | <10 | 722 |  |  |  |  |  |  |  | VERGINIA | GAS  CONVENIENCE STORE | WB | <10 | 101
OREGON | GAS  CONVENIENCE STORE | WB | <10 | 209 |  |  |  |  |  |  |  | [NAME] | GAS  CONVENIENCE STORE | WB | <10 | 48
TEXAS | GAS  CONVENIENCE STORE | WB | <10 | 832 |  |  |  |  |  |  |  | WASHINGTON | GAS  CONVENIENCE STORE | WB | <10 | 642
VERGINIA | GAS  CONVENIENCE STORE | WB | <10 | 101 |  |  |  |  |  |  |  | FLORIDA | GAS  CONVENIENCE STORE | WBL | <10 | 11
[NAME] | GAS  CONVENIENCE STORE | WB | <10 | 48 |  |  |  |  |  |  |  | MARYLAND | GAS  CONVENIENCE STORE | WBL | <10 | 31
WASHINGTON | GAS  CONVENIENCE STORE | WB | <10 | 642 |  |  |  |  |  |  |  | TEXAS | LIQUOR STORE | W | <10 | 8
TEXAS | LIQUOR STORE | WB | >10 | 119 |  |  |  |  |  |  |  | TEXAS | LIQUOR STORE | WB | >10 | 119
TEXAS | LIQUOR STORE | WB | <10 | 1 |  |  |  |  |  |  |  | TEXAS | LIQUOR STORE | WB | <10 | 1
ALABAMA | SUPERMARKET | WB | >10 | 319 |  |  |  |  |  |  |  | FLORIDA | LIQUOR STORE | WBL | >10 | 158
FLORIDA | SUPERMARKET | WB | >10 | 2157 |  |  |  |  |  |  |  | TEXAS | LIQUOR STORE | WBL | >10 | 205
NORTH CAROLINA | SUPERMARKET | WB | >10 | 1169 |  |  |  |  |  |  |  | WASHINGTON | LIQUOR STORE | WBL | >10 | 55
OREGON | SUPERMARKET | WB | >10 | 194 |  |  |  |  |  |  |  | FLORIDA | LIQUOR STORE | WBL | <10 | 1
TEXAS | SUPERMARKET | WB | >10 | 1034 |  |  |  |  |  |  |  | FLORIDA | LIQUOR STORE | WBL | <10 | 23
VERGINIA | SUPERMARKET | WB | >10 | 815 |  |  |  |  |  |  |  | MARYLAND | LIQUOR STORE | WBL | <10 | 1
[NAME] | SUPERMARKET | WB | >10 | 36 |  |  |  |  |  |  |  | TEXAS | LIQUOR STORE | WBL | <10 | 19
WASHINGTON | SUPERMARKET | WB | >10 | 570 |  |  |  |  |  |  |  | FLORIDA | SUPERMARKET | B | <10 | 15
ALABAMA | SUPERMARKET | WB | <10 | 94 |  |  |  |  |  |  |  | TEXAS | SUPERMARKET | W | >10 | 336
DIST OF COLUMBIA | SUPERMARKET | WB | <10 | 16 |  |  |  |  |  |  |  | TEXAS | SUPERMARKET | W | <10 | 17
FLORIDA | SUPERMARKET | WB | <10 | 45 |  |  |  |  |  |  |  | ALABAMA | SUPERMARKET | WB | >10 | 319
MARYLAND | SUPERMARKET | WB | <10 | 2 |  |  |  |  |  |  |  | FLORIDA | SUPERMARKET | WB | >10 | 2157
NORTH CAROLINA | SUPERMARKET | WB | <10 | 2862 |  |  |  |  |  |  |  | NORTH CAROLINA | SUPERMARKET | WB | >10 | 1169
OREGON | SUPERMARKET | WB | <10 | 31 |  |  |  |  |  |  |  | OREGON | SUPERMARKET | WB | >10 | 194
TEXAS | SUPERMARKET | WB | <10 | 2 |  |  |  |  |  |  |  | TEXAS | SUPERMARKET | WB | >10 | 1034
VERGINIA | SUPERMARKET | WB | <10 | 24 |  |  |  |  |  |  |  | VERGINIA | SUPERMARKET | WB | >10 | 815
[NAME] | SUPERMARKET | WB | <10 | 8 |  |  |  |  |  |  |  | [NAME] | SUPERMARKET | WB | >10 | 36
WASHINGTON | SUPERMARKET | WB | <10 | 47 |  |  |  |  |  |  |  | WASHINGTON | SUPERMARKET | WB | >10 | 570
[NAME] | UN CLASIFIED | WB | >10 | 512 |  |  |  |  |  |  |  | ALABAMA | SUPERMARKET | WB | <10 | 94
ALABAMA | UN CLASIFIED | WB | <10 | 1216 |  |  |  |  |  |  |  | DIST OF COLUMBIA | SUPERMARKET | WB | <10 | 16
DIST OF COLUMBIA | UN CLASIFIED | WB | <10 | 453 |  |  |  |  |  |  |  | FLORIDA | SUPERMARKET | WB | <10 | 45
FLORIDA | UN CLASIFIED | WB | <10 | 6653 |  |  |  |  |  |  |  | MARYLAND | SUPERMARKET | WB | <10 | 2
MARYLAND | UN CLASIFIED | WB | <10 | 413 |  |  |  |  |  |  |  | NORTH CAROLINA | SUPERMARKET | WB | <10 | 2862
OREGON | UN CLASIFIED | WB | <10 | 1553 |  |  |  |  |  |  |  | OREGON | SUPERMARKET | WB | <10 | 31
TEXAS | UN CLASIFIED | WB | <10 | 6998 |  |  |  |  |  |  |  | TEXAS | SUPERMARKET | WB | <10 | 2
WASHINGTON | UN CLASIFIED | WB | <10 | 2745 |  |  |  |  |  |  |  | VERGINIA | SUPERMARKET | WB | <10 | 24
FLORIDA | CONVENIENCE STORE | WBL | >10 | 152 |  |  |  |  |  |  |  | [NAME] | SUPERMARKET | WB | <10 | 8
TEXAS | CONVENIENCE STORE | WBL | >10 | 205 |  |  |  |  |  |  |  | WASHINGTON | SUPERMARKET | WB | <10 | 47
FLORIDA | CONVENIENCE STORE | WBL | <10 | 12 |  |  |  |  |  |  |  | FLORIDA | SUPERMARKET | WBL | >10 | 476
MARYLAND | CONVENIENCE STORE | WBL | <10 | 15 |  |  |  |  |  |  |  | TEXAS | SUPERMARKET | WBL | >10 | 34
TEXAS | CONVENIENCE STORE | WBL | <10 | 25 |  |  |  |  |  |  |  | FLORIDA | SUPERMARKET | WBL | <10 | 6
FLORIDA | GAS  CONVENIENCE STORE | WBL | <10 | 11 |  |  |  |  |  |  |  | FLORIDA | UN CLASIFIED | B | <10 | 971
MARYLAND | GAS  CONVENIENCE STORE | WBL | <10 | 31 |  |  |  |  |  |  |  | MARYLAND | UN CLASIFIED | W | >10 | 14
FLORIDA | LIQUOR STORE | WBL | >10 | 158 |  |  |  |  |  |  |  | MARYLAND | UN CLASIFIED | W | <10 | 14
TEXAS | LIQUOR STORE | WBL | >10 | 205 |  |  |  |  |  |  |  | TEXAS | UN CLASIFIED | W | <10 | 2046
WASHINGTON | LIQUOR STORE | WBL | >10 | 55 |  |  |  |  |  |  |  | [NAME] | UN CLASIFIED | WB | >10 | 512
FLORIDA | LIQUOR STORE | WBL | <10 | 1 |  |  |  |  |  |  |  | ALABAMA | UN CLASIFIED | WB | <10 | 1216
FLORIDA | LIQUOR STORE | WBL | <10 | 23 |  |  |  |  |  |  |  | DIST OF COLUMBIA | UN CLASIFIED | WB | <10 | 453
MARYLAND | LIQUOR STORE | WBL | <10 | 1 |  |  |  |  |  |  |  | FLORIDA | UN CLASIFIED | WB | <10 | 6653
TEXAS | LIQUOR STORE | WBL | <10 | 19 |  |  |  |  |  |  |  | MARYLAND | UN CLASIFIED | WB | <10 | 413
FLORIDA | SUPERMARKET | WBL | >10 | 476 |  |  |  |  |  |  |  | OREGON | UN CLASIFIED | WB | <10 | 1553
TEXAS | SUPERMARKET | WBL | >10 | 34 |  |  |  |  |  |  |  | TEXAS | UN CLASIFIED | WB | <10 | 6998
FLORIDA | SUPERMARKET | WBL | <10 | 6 |  |  |  |  |  |  |  | WASHINGTON | UN CLASIFIED | WB | <10 | 2745
FLORIDA | UN CLASIFIED | WBL | <10 | 27 |  |  |  |  |  |  |  | FLORIDA | UN CLASIFIED | WBL | <10 | 27
FLORIDA | UN CLASIFIED | WBL | <10 | 1055 |  |  |  |  |  |  |  | FLORIDA | UN CLASIFIED | WBL | <10 | 1055
MARYLAND | UN CLASIFIED | WBL | <10 | 1027 |  |  |  |  |  |  |  | MARYLAND | UN CLASIFIED | WBL | <10 | 1027
TEXAS | UN CLASIFIED | WBL | <10 | 1981 |  |  |  |  |  |  |  | TEXAS | UN CLASIFIED | WBL | <10 | 1981
WASHINGTON | UN CLASIFIED | WBL | <10 | 3 |  |  |  |  |  |  |  | WASHINGTON | UN CLASIFIED | WBL | <10 | 3
MARYLAND | UN CLASIFIED | WL | <10 | 2 |  |  |  |  |  |  |  | MARYLAND | UN CLASIFIED | WL | <10 | 2