Excel - Multiple Workbooks
 

I want to know the total of all counts of a specific cell from over 100
different excel worksheets. It is the same cell on each sheet. Don't want to
have to open each worksheet.

Excel - Multiple Workbooks
 

If the worksheets you want to add are consecutive (there are no 'other'
worksheets between the first and the last), =SUM('First Sheet:Last Sheet'!A1)
(replace First Sheet and Last Sheet with the appropriate worksheet names, and
A1 with the cell you want to add. (If you really do want a count of the
cells rather than a sum, use the function COUNT where I've SUM).

"OB1" wrote:

I want to know the total of all counts of a specific cell from over 100
different excel worksheets. It is the same cell on each sheet. Don't want to
have to open each worksheet.

Excel - Multiple Workbooks
 

I used worksheet when I should have said workbook. These are each separate
files. My SUM function would have to look at all of the files in a folder.
Probably can not do this without opening each workbook. Just thought I would
check to save some time.

"bpeltzer" wrote:

If the worksheets you want to add are consecutive (there are no 'other'
worksheets between the first and the last), =SUM('First Sheet:Last Sheet'!A1)
(replace First Sheet and Last Sheet with the appropriate worksheet names, and
A1 with the cell you want to add. (If you really do want a count of the
cells rather than a sum, use the function COUNT where I've SUM).

"OB1" wrote:

I want to know the total of all counts of a specific cell from over 100
different excel worksheets. It is the same cell on each sheet. Don't want to
have to open each worksheet.

Excel - Multiple Workbooks
 

Found the answer he
http://www.rondebruin.nl/copy3.htm
Thanks!

"OB1" wrote:

I used worksheet when I should have said workbook. These are each separate
files. My SUM function would have to look at all of the files in a folder.
Probably can not do this without opening each workbook. Just thought I would
check to save some time.

"bpeltzer" wrote:

If the worksheets you want to add are consecutive (there are no 'other'
worksheets between the first and the last), =SUM('First Sheet:Last Sheet'!A1)
(replace First Sheet and Last Sheet with the appropriate worksheet names, and
A1 with the cell you want to add. (If you really do want a count of the
cells rather than a sum, use the function COUNT where I've SUM).

"OB1" wrote:

I want to know the total of all counts of a specific cell from over 100
different excel worksheets. It is the same cell on each sheet. Don't want to
have to open each worksheet.

Excel - Multiple Workbooks
 

You can also create links to the cells
http://www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"OB1" wrote in message ...
Found the answer he
http://www.rondebruin.nl/copy3.htm
Thanks!

"OB1" wrote:

I used worksheet when I should have said workbook. These are each separate
files. My SUM function would have to look at all of the files in a folder.
Probably can not do this without opening each workbook. Just thought I would
check to save some time.

"bpeltzer" wrote:

If the worksheets you want to add are consecutive (there are no 'other'
worksheets between the first and the last), =SUM('First Sheet:Last Sheet'!A1)
(replace First Sheet and Last Sheet with the appropriate worksheet names, and
A1 with the cell you want to add. (If you really do want a count of the
cells rather than a sum, use the function COUNT where I've SUM).

"OB1" wrote:

I want to know the total of all counts of a specific cell from over 100
different excel worksheets. It is the same cell on each sheet. Don't want to
have to open each worksheet.