How to get count of subfolders and files

[m_vishal_c]

HI
i have been looking to internet for the solution but i can not get it. Problem is

i do have list of all files and folders path in column (i.e A), i have applied dropdown list on column A.
if i select
(1) "General" from dropdown list it should gives me count like 17 (as per below image),
(2) If i select General/ABC then it counts 9 (including subfolders)
(3) if i select General/ABC/ABC1 then the count will be 7

can you please help me how can i get. heaps thanks in advance

Path

General

General/ABC

General/ABC/ABC1

General/ABC/ABC1/ABC1 - Report1

General/ABC/ABC1/ABC1 - Report2

General/ABC/ABC1/ABC2

General/ABC/ABC1/ABC2/Fun 2022

General/ABC/ABC1/ABC2/ABC3

General/ABC/ABC1/ABC2/ABC3/ABC4

General/ABC/ABCDE

General/XYZ

General/XYZ/MARSH

General/XYZ/MARSH/EARTH

General/XYZ/LAND

General/XYZ/LAND/HOUSE

General/XYZ/LANDSCAPE

General/XYZ/LANDSCAPE/BIKE

 

[Zot]

Is this solve your problem?

count subfolders

Hi, I have code to count files in folders... I need help writing vba to just count the subfolders in a folder. (needs to include all nested subfolders) thanks, peter

www.mrexcel.com