# Sum across workbooks

#### teebruin

##### New Member
I have about 50 copies of the same worksheet, and quantities were added to each worksheet. Is there any shortcuts that I can use to sum all the different quantities from the different copies of the same worksheet? Or, will I just have to go in and manually do it? Just wondering.

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
On 2002-09-20 16:27, teebruin wrote:
I have about 50 copies of the same worksheet, and quantities were added to each worksheet. Is there any shortcuts that I can use to sum all the different quantities from the different copies of the same worksheet? Or, will I just have to go in and manually do it? Just wondering.

=SUM(Sheet1:Sheet10!A1:A10)

would sum every A1:A10 range of values in Sheet1, Sheet2,..., and Sheet10.

I think I misspoke. I have 50 copies of the same workbook. I need to sum the same cells in about 50 separate workbooks. Is there a way to do this similar to the sheets example given above?

On 2002-09-20 17:19, teebruin wrote:
I think I misspoke. I have 50 copies of the same workbook. I need to sum the same cells in about 50 separate workbooks. Is there a way to do this similar to the sheets example given above?

Hi teebruin:

I am not quite sure what you are trying to do ... if you have 50 copies of the same workbook with identical entries in all cells, then the sum of values in certain cells would be 50 times the sum of the relevant cells in the worksheets of one workbook.

However if the cell values in workbooks are different, you may do something like is shown in my worksheet simulation ...
Book3
GHIJK
22
23WorkbookSheetStartCellEndCellsum
24[y020920a.xls]Sheet1!A1A1055
25[y020920b.xls]Sheet3!B1B10155
26[y020920c.xls]Sheet1!A1A1055
27265
28
Sheet4
</SPAN>

I hope this helps.

Regards!

Yogi
This message was edited by Yogi Anand on 2002-09-20 19:55

Thanks Yogi. I've been trying to adapt your formula, but no luck yet. This issue pops up from time to time, and I just usually do it manually.

The situation is this:

I sent out a workbook to about 50 different people so they can place orders, then they sent it back to me. Column A on each workbook will have quantities for different items, i.e. A4 is qty for item 1, A5 is qty for item 2 and so forth. I want to create a spreadsheet that will go out and total A4 from all 50 workbooks, and then in another cell sum A5 from all 50 workbooks, and so forth for all items.

I hope this is a clearer picture of my question.

Thanks!

On 2002-09-23 11:03, teebruin wrote:
Thanks Yogi. I've been trying to adapt your formula, but no luck yet. This issue pops up from time to time, and I just usually do it manually.

The situation is this:

I sent out a workbook to about 50 different people so they can place orders, then they sent it back to me. Column A on each workbook will have quantities for different items, i.e. A4 is qty for item 1, A5 is qty for item 2 and so forth. I want to create a spreadsheet that will go out and total A4 from all 50 workbooks, and then in another cell sum A5 from all 50 workbooks, and so forth for all items.

I hope this is a clearer picture of my question.

Thanks!

Maybe you can use GetValue:

http://j-walk.com/ss/excel/tips/tip82.htm
This message was edited by Aladin Akyurek on 2002-09-23 12:34

Replies
4
Views
307
Replies
0
Views
234
Replies
2
Views
192
Replies
1
Views
214
Replies
1
Views
182

1,221,412
Messages
6,159,731
Members
451,588
Latest member
tsg178

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back