1 Reply Latest reply on May 30, 2014 1:31 PM by Don Barnetson

    referencing data in multiple sheets on the same workbook

    Lee Hadden

      Hi,

       

      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.

       

      Thanks,

       

      Lee

       

      N.B. I keep getting an error message when attempting an upload of the test file.