Edited the original post, I was using "=Sum(B3:B4)" for the second row of the second table and copied it onto the rest of the cells in the column but neglected to adjust them individually after getting sidetracked.
@Grey Acumen & Tyrone,
Your raw numbers are correct but I was going another way with the percentages. Neither is wrong but I was trying to show something different than you two were. Especially with Grey some of what you thought was a mistake was actually me trying to show the data in a different format than what you were expecting.








