How to subtract with 3D between 3 worksheets

T

Tabis

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.
 
T

Tabis

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

cm

wherever your cells are that you are subtracting -- Sheet1 and SHeet2 are
the sheet names and then e22 would be the cell reference in each sheet:

to subtract e22 in sheet 2 from e22 in sheet 1:

=Sheet1!e22 - Sheet2!e22
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to write 3D formula averaging total sales between 3 workshee 3
3D worksheet question 1
Copying formula vertically, to pick up horizontal cell values 3
Pivot table help. 2
determine a range using a formula 2
3d References 7
multiple work sheet data to link in one worksheet 6
Excel - Formulae across several sheets 2

Top