How can I subtract cells in two different worksheets?

C

Carl M

I want to subtract cells located in two different workhetts, and place the
answer in the 3rd. Ho can I
 
K

Kevin B

In the cell where you want the result, type the following formula changing
the workbook name, sheet name and cell address as needed:

=[WorkBook2]Sheet1!$A$1-[WorkBook1]Sheet1!$A$1

Hope this helps.
 
D

David Biddulph

Wherever you want the answer, type =, then go to the cell from which you
want to subtract, and click in that cell, then type -, then go to the cell
you wish to subtract, click there, and then accept the formula.
You'll get something like =Sheet1!A1-Sheet2!B2
 
Top