Excel Question: how to count multiple external files

HIROYUKI TAMURA
HIROYUKI TAMURA used Ask the Experts™
on
I would like to count a value from external Excel files

I have three files, File1.xlsx, File2.xlsx, File3.xlsx
I would like to count on a certain colum on each files and output on Count.xlsx
Please advise.
file1.xlsx
file2.xlsx
file3.xlsx
Count.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can use sumproduct to do that.

With all files in the same folder attached file will work.
Count.xlsx
NoahHardware Tester and Debugger

Commented:
Hi there! :)

The other way is to create a Pivot table which consolidates data from multiple workbooks. You will need the Power Query Add-in. If it is already installed, you can immediately follow the guide below.

You can download it here:
https://www.microsoft.com/en-sg/download/details.aspx?id=39379

Here is a guide and there is a tutorial video:
http://www.ashishmathur.com/create-a-pivot-table-from-multiple-worksheets-in-different-workbooks/

You will also need to ensure that the data in the data files are already in tables.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial