Thread: add two cells from seperate work sheets into a cell on seperate wo
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default add two cells from seperate work sheets into a cell on seperate wo
What does "add" mean to you?

"SUM" or "combine contents"?

To SUM =Sheet1!A1 + Sheet2!B3

To combine contents

=Sheet1A1 & Sheet2!B3


Gord Dibben MS Excel MVP

On Tue, 27 Apr 2010 07:35:01 -0700, lar
wrote:

I have two cells on one work sheet that I want to add together in a cell on
another work sheet.
And is it possible to add together two cells on seperate work sheets in a
cell on third work sheet

Reply With QuoteReply With Quote