Spreadsheet: 86771d1286747042-formatting-by-matching-columns-a-and-b-statespviot
Sheet: Sheet2

Month | State | Count | Amount |  |  | Column Labels
Jan | AK | 7 | 11453.89 |  |  | Jan |  | Feb |  | Mar |  | Total Sum of Count | Total Sum of Amount
Jan | AL | 3 | 476 |  | Row Labels | Sum of Count | Sum of Amount | Sum of Count | Sum of Amount | Sum of Count | Sum of Amount
Jan | AZ | 51 | 53496.58 |  | AK | 7 | 11453.89 |  |  | 1 | 96.71 | 8 | 11550.6
Jan | CA | 54 | 182717.72 |  | AL | 3 | 476 |  |  | 1 | 49.37 | 4 | 525.37
Jan | CO | 15 | 13368.82 |  | AR |  |  |  |  | 6 | 11584.22 | 6 | 11584.22
Jan | CT | 198 | 544609.99 |  | AZ | 51 | 53496.58 | 28 | 37848.21 | 38 | 76667.52 | 117 | 168012.31
Jan | DE | 2 | 2728.55 |  | CA | 54 | 182717.72 | 85 | 174610.6 | 28107 | 50842701.92 | 28246 | 51200030.24
Jan | FL | 10 | 20335.67 |  | CO | 15 | 13368.82 | 8812 | 9776433.72 | 8 | 18399.11 | 8835 | 9808201.65
Jan | GA | 44 | 30043.84 |  | CT | 198 | 544609.99 | 19 | 45918.62 | 55 | 116012.98 | 272 | 706541.59
Jan | HI | 87 | 80182.65 |  | DC |  |  |  |  | 17 | 17567.92 | 17 | 17567.92
Jan | IL | 30 | 168437.41 |  | DE | 2 | 2728.55 |  |  | 1 | 322.56 | 3 | 3051.11
Jan | IN | 713 | 795100.87 |  | FL | 10 | 20335.67 | 48 | 336449.01 | 46 | 362724.2 | 104 | 719508.88
Jan | KS | 3 | 9015.14 |  | GA | 44 | 30043.84 | 24 | 26464.64 | 135 | 54090.21 | 203 | 110598.69
Jan | KY | 13 | 11697.35 |  | HI | 87 | 80182.65 |  |  |  |  | 87 | 80182.65
Jan | LA | 14 | 17569.01 |  | IA |  |  | 1 | 803 | 160 | 230095 | 161 | 230898
Jan | MA | 4577 | 5240255.36 |  | ID |  |  | 5 | 817.62 | 1 | 60.46 | 6 | 878.08
Jan | MD | 5 | 7934.63 |  | IL | 30 | 168437.41 | 2691 | 7069376.73 | 9 | 19680.25 | 2730 | 7257494.390000001
Jan | ME | 50 | 41427.85 |  | IN | 713 | 795100.87 | 9 | 27258.58 | 17 | 17659.36 | 739 | 840018.8099999999
Jan | MI | 38 | 101847.68 |  | KS | 3 | 9015.14 |  |  | 2 | 2058.64 | 5 | 11073.78
Jan | MN | 12 | 18184.23 |  | KY | 13 | 11697.35 | 5 | 4230.09 | 4 | 1609.05 | 22 | 17536.49
Jan | MO | 1 | 1565.73 |  | LA | 14 | 17569.01 | 4 | 5704.74 | 3 | 9069.74 | 21 | 32343.49
Jan | NC | 11 | 26191.4 |  | MA | 4577 | 5240255.36 | 507 | 593531.67 | 23 | 33204.96 | 5107 | 5866991.99
Jan | NH | 4 | 6369.35 |  | MD | 5 | 7934.63 | 15 | 26273.07 | 48 | 42758.53 | 68 | 76966.23
Jan | NJ | 5329 | 10871016.01 |  | ME | 50 | 41427.85 | 160 | 263707.31 | 136 | 208260.96 | 346 | 513396.12
Jan | NV | 95 | 93966.17 |  | MI | 38 | 101847.68 | 27 | 48263.43 | 22 | 57139.87 | 87 | 207250.98
Jan | NY | 215 | 407816.24 |  | MN | 12 | 18184.23 | 15 | 34648.47 | 30 | 66298.77 | 57 | 119131.47
Jan | OH | 2126 | 3389012.83 |  | MO | 1 | 1565.73 | 2 | 4688.64 | 3 | 5648.86 | 6 | 11903.23
Jan | OK | 2 | 1571.77 |  | NC | 11 | 26191.4 | 4 | 2181.4 | 4 | 7068.94 | 19 | 35441.74000000001
Jan | OR | 3 | 9257.57 |  | NE |  |  | 129 | 219346.27 | 24 | 34087.48 | 153 | 253433.75
Jan | PA | 45 | 81144.57 |  | NH | 4 | 6369.35 |  |  | 7 | 9213.71 | 11 | 15583.06
Jan | RI | 130 | 154219.74 |  | NJ | 5329 | 10871016.01 | 105 | 234530.46 | 75 | 158721.59 | 5509 | 11264268.06
Jan | SC | 8 | 11688.53 |  | NM |  |  | 1 | 807.22 | 1 | 1153.31 | 2 | 1960.53
Jan | TN | 1 | 3853.29 |  | NV | 95 | 93966.17 | 3342 | 1952814.14 | 53 | 18456.14 | 3490 | 2065236.45
Jan | TX | 40 | 87113.41 |  | NY | 215 | 407816.24 | 25 | 43483.76 | 86 | 85898.99 | 326 | 537198.99
Jan | UT | 15 | 26176.79 |  | OH | 2126 | 3389012.83 | 531 | 755153.57 | 11 | 33290.89 | 2668 | 4177457.29
Jan | VA | 9 | 13807.97 |  | OK | 2 | 1571.77 | 1 | 2827.88 | 1 | 2036.31 | 4 | 6435.959999999999
Jan | VT | 17 | 22293.27 |  | OR | 3 | 9257.57 | 2 | 4742.89 | 3 | 21517.44 | 8 | 35517.89999999999
Jan | WA | 18 | 31424.84 |  | PA | 45 | 81144.57 | 1639 | 1603457.43 | 982 | 845537.72 | 2666 | 2530139.72
Jan | WI | 2 | 9818.85 |  | RI | 130 | 154219.74 | 108 | 120790 | 268 | 263372.33 | 506 | 538382.0700000001
Jan | WV | 3 | 2983.61 |  | SC | 8 | 11688.53 | 6 | 6073.05 |  |  | 14 | 17761.58
Feb | AZ | 28 | 37848.21 |  | SD |  |  |  |  | 42 | 50580.32 | 42 | 50580.32
Feb | CA | 85 | 174610.6 |  | TN | 1 | 3853.29 |  |  | 4 | 5226 | 5 | 9079.29
Feb | CO | 8812 | 9776433.72 |  | TX | 40 | 87113.41 | 11 | 39886.3 | 13 | 26455.92 | 64 | 153455.63
Feb | CT | 19 | 45918.62 |  | UT | 15 | 26176.79 |  |  | 6 | 393.74 | 21 | 26570.53
Feb | FL | 48 | 336449.01 |  | VA | 9 | 13807.97 | 77 | 60117.16 | 66 | 37278.29 | 152 | 111203.42
Feb | GA | 24 | 26464.64 |  | VT | 17 | 22293.27 | 20 | 33684.96 | 1 | 1617.05 | 38 | 57595.28
Feb | IA | 1 | 803 |  | WA | 18 | 31424.84 | 21 | 55561.56 | 66 | 51421.22 | 105 | 138407.62
Feb | ID | 5 | 817.62 |  | WI | 2 | 9818.85 | 4 | 19467.48 | 2 | 11928.17 | 8 | 41214.5
Feb | IL | 2691 | 7069376.73 |  | WV | 3 | 2983.61 | 41 | 23540.23 |  |  | 44 | 26523.84
Feb | IN | 9 | 27258.58 |  | Grand Total | 14000 | 22602175.18 | 18524 | 23655493.91 | 30588 | 53859016.73000001 | 63112 | 100116685.82
Feb | KY | 5 | 4230.09
Feb | LA | 4 | 5704.74
Feb | MA | 507 | 593531.67
Feb | MD | 15 | 26273.07
Feb | ME | 160 | 263707.31
Feb | MI | 27 | 48263.43
Feb | MN | 15 | 34648.47
Feb | MO | 2 | 4688.64
Feb | NC | 4 | 2181.4
Feb | NE | 129 | 219346.27
Feb | NJ | 105 | 234530.46
Feb | NM | 1 | 807.22
Feb | NV | 3342 | 1952814.14
Feb | NY | 25 | 43483.76
Feb | OH | 531 | 755153.57
Feb | OK | 1 | 2827.88
Feb | OR | 2 | 4742.89
Feb | PA | 1639 | 1603457.43
Feb | RI | 108 | 120790
Feb | SC | 6 | 6073.05
Feb | TX | 11 | 39886.3
Feb | VA | 77 | 60117.16
Feb | VT | 20 | 33684.96
Feb | WA | 21 | 55561.56
Feb | WI | 4 | 19467.48
Feb | WV | 41 | 23540.23
Mar | AK | 1 | 96.71
Mar | AL | 1 | 49.37
Mar | AR | 6 | 11584.22
Mar | AZ | 38 | 76667.52
Mar | CA | 28107 | 50842701.92
Mar | CO | 8 | 18399.11
Mar | CT | 55 | 116012.98
Mar | DC | 17 | 17567.92
Mar | DE | 1 | 322.56
Mar | FL | 46 | 362724.2
Mar | GA | 135 | 54090.21
Mar | IA | 160 | 230095
Mar | ID | 1 | 60.46
Mar | IL | 9 | 19680.25
Mar | IN | 17 | 17659.36
Mar | KS | 2 | 2058.64
Mar | KY | 4 | 1609.05
Mar | LA | 3 | 9069.74
Mar | MA | 23 | 33204.96
Mar | MD | 48 | 42758.53
Mar | ME | 136 | 208260.96
Mar | MI | 22 | 57139.87
Mar | MN | 30 | 66298.77
Mar | MO | 3 | 5648.86
Mar | NC | 4 | 7068.94
Mar | NE | 24 | 34087.48
Mar | NH | 7 | 9213.71
Mar | NJ | 75 | 158721.59
Mar | NM | 1 | 1153.31
Mar | NV | 53 | 18456.14
Mar | NY | 86 | 85898.99
Mar | OH | 11 | 33290.89
Mar | OK | 1 | 2036.31
Mar | OR | 3 | 21517.44
Mar | PA | 982 | 845537.72
Mar | RI | 268 | 263372.33
Mar | SD | 42 | 50580.32
Mar | TN | 4 | 5226
Mar | TX | 13 | 26455.92
Mar | UT | 6 | 393.74
Mar | VA | 66 | 37278.29
Mar | VT | 1 | 1617.05
Mar | WA | 66 | 51421.22
Mar | WI | 2 | 11928.17