If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
add two cells from seperate work sheets into a cell on seperate wo
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 |
#2
|
|||
|
|||
add two cells from seperate work sheets into a cell on seperate wo
Hi,
When you say add do you mean sum and different worksheets are different files? if the answer is yes and let's assume that the worksheet names are A, B and C and the information is in that sheets in the tab called Sheeet1 and the information is to be summarize in worksheet C =+[A]Sheet1!$A$1+[b]Sheet1!$A$2 "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 |
#3
|
|||
|
|||
add two cells from seperate work sheets into a cell on seperate wo
Within worksheets; just mention the sheet name and the cell referrnce as below
=Sheet1!C28+Sheet2!D25 -- Jacob (MVP - Excel) "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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
add two cells from seperate work sheets into a cell on seperate wo
Eduardo
Maybe you should check out help on the difference between "Worksheet" and "Workbook" Gord Dibben MS Excel MVP On Tue, 27 Apr 2010 08:02:01 -0700, Eduardo wrote: Hi, When you say add do you mean sum and different worksheets are different files? if the answer is yes and let's assume that the worksheet names are A, B and C and the information is in that sheets in the tab called Sheeet1 and the information is to be summarize in worksheet C =+[A]Sheet1!$A$1+[b]Sheet1!$A$2 "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 |
#6
|
|||
|
|||
add two cells from seperate work sheets into a cell on seperat
Hi Gord,
I know the difference but I wasn't sure what he try to say, it happens to me last year somebody giving the same description and was refering to different workbooks, this is why I asked if he means different files "Gord Dibben" wrote: Eduardo Maybe you should check out help on the difference between "Worksheet" and "Workbook" Gord Dibben MS Excel MVP On Tue, 27 Apr 2010 08:02:01 -0700, Eduardo wrote: Hi, When you say add do you mean sum and different worksheets are different files? if the answer is yes and let's assume that the worksheet names are A, B and C and the information is in that sheets in the tab called Sheeet1 and the information is to be summarize in worksheet C =+[A]Sheet1!$A$1+[b]Sheet1!$A$2 "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 . |
#7
|
|||
|
|||
add two cells from seperate work sheets into a cell on seperat
But then you used the term "worksheet" names A, B and C with tab called
Sheet1 I guess you meant to say "workbook" names A, B and C Gord On Tue, 27 Apr 2010 10:16:04 -0700, Eduardo wrote: Hi Gord, I know the difference but I wasn't sure what he try to say, it happens to me last year somebody giving the same description and was refering to different workbooks, this is why I asked if he means different files "Gord Dibben" wrote: Eduardo Maybe you should check out help on the difference between "Worksheet" and "Workbook" Gord Dibben MS Excel MVP On Tue, 27 Apr 2010 08:02:01 -0700, Eduardo wrote: Hi, When you say add do you mean sum and different worksheets are different files? if the answer is yes and let's assume that the worksheet names are A, B and C and the information is in that sheets in the tab called Sheeet1 and the information is to be summarize in worksheet C =+[A]Sheet1!$A$1+[b]Sheet1!$A$2 "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 . |
Thread Tools | |
Display Modes | |
|
|