Well, in the past few hours I managed to come up with a solution (see uploaded excel file), the part that I got stuck at is...
...how do you add up the % numbers in column D, so that numbers that belong to the Yes votes totaled in cell E18, the No votes in E19 and so on?
Probably you can see, that my overall solution isn't on the Phd level, probably there is a more elegant way to change a range of cells to a certain value than how I did, but this works for me.
