should the formula be =sheet1!E22:sheet2!E22, cause this is adding not
subtracting? Thanks for your help?

"cm" wrote:

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.