I've got a confusing question, I can't figure it out. I have this spreadsheet of states population and their political control, each on separate alternating rows (political control is designated with a text value like R3, R2, R1, D3, D2, D1, etc.):
What I want is the sum of the population of all states that fall under a specific category of political control. So what is the total population of all the "R3" states in 2019? This would mean the sum of the population for Alabama in 2019, Arizona in 2019, etc since these states all have political control of "R3". Same for the total population for "R2" states, "D3" states, etc. Basically, for each unique text value, I want the sum of all the cells below that text value for each year. Any idea of how I could calculate this or how I could rearrange my spreadsheet easily to make this more manageable?