Spreadsheet: 219258d1362693183-make-a-sumif-formula-dynamic-book2
Sheet: book 1

 |  |  | Rollup of Actual/Estimate volume by State (for pricing modelling) |  |  |  |  |  |  |  | RE_v01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RenRE_v05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ConsumerSales_v03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RenConsumerSales_v05
 |  |  | 2013
 |  |  |  | Actual
 |  |  |  | CS |  |  |  |  | CF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BQ
 |  |  |  | B
 |  |  |  | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  | 61
 |  |  |  | 71 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  | 74 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012 | 2012 | 2012 | 2012 | 2013 | 2013 | 2013 | 2013 |  | 2012 | 2013
 | "Quick & dirty" RE division | RE ST Divmix | State | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec |  | DTC Statemix | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec |  |  | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | June | July | Aug | Sept | Oct | Nov | Dec |  |  |  |  |  |  |  |  |  |  |  | 2012 | 2013
 | West/Midwest Division |  | AK | 1
 | Eastern Division |  | AL | 1
 | Central Division |  | AR | 1
 | West/Midwest Division |  | AZ | 1
 | Southwest Division |  | CA | 1
 | West/Midwest Division |  | CO | 1
 | National Division |  | CT | 1
 | Eastern Division |  | DC | 1
 | Eastern Division |  | DE | 1
 | First Warranty |  | FL | 1
 | Central Division |  | GA | 1
 | National Division |  | HI | 1
 | National Division |  | HS | 1
 | National Division |  | IA | 1
 | West/Midwest Division |  | ID | 1
 | National Division |  | IL | 1
 | Eastern Division |  | IN | 1
 | West/Midwest Division |  | KS | 1
 | Eastern Division |  | KY | 1
 | National Division |  | LA | 1
 | National Division |  | MA | 1
 | Eastern Division |  | MD | 1
 | National Division |  | ME | 1
 | Eastern Division |  | MI | 1
 | National Division |  | MN | 1
 | Central Division |  | MO | 1
 | Central Division |  | MS | 1
 | West/Midwest Division |  | MT | 1
 | Central Division |  | NC | 1
 | West/Midwest Division |  | ND | 1
 | Central Division |  | NE | 1
 | National Division |  | NH | 1
 | Eastern Division |  | NJ | 1
 | Central Division |  | NM | 1
 | West/Midwest Division |  | NV | 1
 | National Division |  | NY | 1
 | Eastern Division |  | OH | 1
 | Central Division |  | OK | 1
 | West/Midwest Division |  | OR | 1
 | Eastern Division |  | PA | 1
 | National Division |  | RI | 1
 | Central Division |  | SC | 1
 | West/Midwest Division |  | SD | 1
 | Eastern Division |  | TN | 1
 | Central Division |  | TX | 1
 | West/Midwest Division |  | UT | 1
 | Eastern Division |  | VA | 1
 | National Division |  | VT | 1
 | West/Midwest Division |  | WA | 1
 | National Division |  | WI | 1
 | Eastern Division |  | WV | 1
 | West/Midwest Division |  | WY | 1
 |  |  | Monthly Totals