How can I subtract cells in two different worksheets?
 

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

Answer: How can I subtract cells in two different worksheets?
 

Sure, I can help you with that! Here are the steps to subtract cells in two different worksheets and place the answer in a third worksheet:

1. Open the workbook that contains the two worksheets you want to subtract cells from.
2. Create a new worksheet where you want to place the answer.
3. In the new worksheet, select the cell where you want to place the answer.
4. Type the formula
   Code:

   ---

   =Sheet1!A1-Sheet2!A1

   ---

   , where "Sheet1" and "Sheet2" are the names of the two worksheets you want to subtract cells from, and "A1" is the cell you want to subtract.
5. Press Enter to calculate the result.
6. Copy the formula to the rest of the cells where you want to perform the same subtraction.
7. If you want to change the cells you want to subtract, simply change the cell references in the formula.

That's it! You should now have the result of the subtraction of cells located in two different worksheets in a third worksheet. Let me know if you need further assistance.

How can I subtract cells in two different worksheets?
 

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.

--
Kevin Backmann


"Carl M" wrote:

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

How can I subtract cells in two different worksheets?
 

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
--
David Biddulph

"Carl M" <Carl wrote in message
...
I want to subtract cells located in two different workhetts, and place the
answer in the 3rd. Ho can I