ExcelBanter - How to subtract with 3D between 3 worksheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to subtract with 3D between 3 worksheets (https://www.excelbanter.com/excel-worksheet-functions/244331-re-how-subtract-3d-between-3-worksheets.html)

How to subtract with 3D between 3 worksheets

referece the cells in sheets 1 and 2 like this:

=Sheet1!E22

"Tabis" wrote:

I have 3 worksheets. First one with budgeted sales, second with actual sales
and I need to use a 3D reference to get the variance on sheet three.

All times are GMT +1. The time now is 08:29 AM.