How can I subtract cells in two different worksheets?

[Carl M]

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

 

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

 

[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