Link to home
Start Free TrialLog in
Avatar of Hiro 714
Hiro 714

asked on

Excel Question: how to count multiple external files

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.
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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:

Here is a guide and there is a tutorial video:

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