Have a question

[DEVON AINSWORTH]

I hope this is not a repost...

I have a Excel Workbook with four tabs. Now I want to get information from 1-3 (totals) tabs and place that information into some cells on tab 4. I don't want to cut and paste, I would like it to be a =sum or something like that.

Can this be done?

 

[JosephByrns]

Do you mean something like this?

=Sheet1!D7+Sheet2!C6+Sheet3!C3


I hope this is not a repost...

I have a Excel Workbook with four tabs. Now I want to get information from 1-3 (totals) tabs and place that information into some cells on tab 4. I don't want to cut and paste, I would like it to be a =sum or something like that.

Can this be done?

 

[Dana DeLouis]

If the sheets to total are together, perhaps the following...
On Sheet4, in cell say A1, enter: =Sum(
...Now, with the mouse, select Sheet1. Hold the Shift key, and select Sheet3.
This selects all Sheets 1,2,&3.
While on Sheet3, select say A1, and now press Enter.
The formula intered on Sheet4, in A1 is now:
=SUM(Sheet1:Sheet3!A1)

If your Sheet names have spaces, then use the ' character:
=SUM('Sheet 1:Sheet 3'!A1)

--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003


I hope this is not a repost...

I have a Excel Workbook with four tabs. Now I want to get information from
1-3 (totals) tabs and place that information into some cells on tab 4. I
don't want to cut and paste, I would like it to be a =sum or something like
that.

Can this be done?

 

[DEVON AINSWORTH]

WOW

Thx everyone

--
DEVON AINSWORTH
I hope this is not a repost...

I have a Excel Workbook with four tabs. Now I want to get information from 1-3 (totals) tabs and place that information into some cells on tab 4. I don't want to cut and paste, I would like it to be a =sum or something like that.

Can this be done?