How to subtract cells of two different Spreadsheet

[Kaesav]

I want to subtract cells located in two different worksheets, and place the answer in the 3rd. Ho can I do that. I tried using some cross reference via hyperlink but that does not worked. Is there any add-in for the same.

[DanielaA]

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.

[QUENBY]

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.