Excel - Multiple Workbooks

O

OB1

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.
 
B

bpeltzer

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).
 
O

OB1

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.
 
Top