How to count files in a certain folder / directory in Excel

If you need to get the number of files in a certain folder in Excel, which method will you think of? How about counting the number of specific type of files in a folder? And what if counting files in a certain folder and its subfolders in Excel? The following tricks will help you solve it easily.

More details: