I am doing some research on Presidential elections and wish to sort the results by which region the nation is located in. Here is a look at the data as I have it presented. (the numbers are based on the 2012 Presidential Election)
<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody></tbody>
<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
What I would like to do is to run a VLOOKUP or SUMIF(S) (unsure of which one, or if these are the best) to sum the number of votes for each party in each region. On a separate sheet, here is how I'd like to allocate the votes. (the national results are incomplete but serve as an example; the Midwest and Northeast ARE complete). The regions are based on the Census allocation of each state.
<colgroup><col><col><col><col span="7"></colgroup><tbody>
</tbody>
Could anyone suggest to me what formulas I should use for this situation?
<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody></tbody>
State | Region | Dem | Rep | Ind | Oth | Tot | |
Alabama | South | 795,696 | 1,255,925 | 12,328 | 10,389 | 2,074,338 | |
Alaska | West | 122,640 | 164,676 | 7,392 | 5,787 | 300,495 | |
Arizona | West | 1,025,232 | 1,233,654 | 32,100 | 15,573 | 2,306,559 | |
Arkansas | South | 394,409 | 647,744 | 16,276 | 11,039 | 1,069,468 | |
California | West | 7,854,285 | 4,839,958 | 143,221 | 218,351 | 13,055,815 | |
Colorado | West | 1,322,998 | 1,185,050 | 35,545 | 27,956 | 2,571,549 | |
Connecticut | Northeast | 905,109 | 634,899 | 12,580 | 6,405 | 1,558,993 | |
D.C. | South | 267,070 | 21,381 | 2,083 | 3,230 | 293,764 | |
Delaware | South | 242,584 | 165,484 | 3,882 | 1,971 | 413,921 |
<colgroup><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
What I would like to do is to run a VLOOKUP or SUMIF(S) (unsure of which one, or if these are the best) to sum the number of votes for each party in each region. On a separate sheet, here is how I'd like to allocate the votes. (the national results are incomplete but serve as an example; the Midwest and Northeast ARE complete). The regions are based on the Census allocation of each state.
<colgroup><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col span="7"></colgroup><tbody>
</tbody>
Could anyone suggest to me what formulas I should use for this situation?