I would like to be able to calculate the percentage between two totals in 2 sheets of the same workbook.
In the attachment, there are the Total Sales for 2 groups of States, i would like to be able to create a percentage between the two of them, any ideas would be most welcome.
N.B. I keep getting an error message when attempting an upload of the test file.
I'm sure there's a way to do this. If not, there should be. I'm working on a few theories right now. I'll keep you posted.