I just realized that i need one more thing right now, the formula you gave works perfectly by the way !

Currently, it looks like this: =SUM(A3:A11)/SUM(A3:B11) and i have it in a cell below A11.

What i need, is to get a percentage of Three pairs of Columns. Can 2 Columns be added together? If so, i need the total sum for columns A3:A11 and B3:B11.

I need a formula for that. I can possibly figure out how to change it to work for D and E, and G and H as well.

The totals of all 6 columns will end up being a grand total of 100%.

What percent is Columns A3:A11 and B3:B11 added together, from that grand total?

What percent of Columns D3:D11 and E3:E11 added together, from that grand total?

What percent is Columns A3:A11 and B3:B11 added together, from that grand total?