Sum across workbooks

teebruin

New Member
Joined
Mar 28, 2002
Messages
38
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.

Thanks in advance.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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.

Thanks in advance.

=SUM(Sheet1:Sheet10!A1:A10)

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

teebruin

New Member
Joined
Mar 28, 2002
Messages
38
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?
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454

ADVERTISEMENT

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
 

teebruin

New Member
Joined
Mar 28, 2002
Messages
38
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!
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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
 

Forum statistics

Threads
1,144,510
Messages
5,724,786
Members
422,579
Latest member
Lekha mohanty

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top