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.

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.

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.

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.

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.