Thread: How can I subtract cells in two different worksheets?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
  
Posts: 1,316
Default 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
Reply With QuoteReply With Quote