Hi,

I have a massive spreadsheet of directory URLs and the number of pages there. I can only find out the number of pages under the lowest level directory.

e.g.
/website/pm/test/1/ ---- 5
/website/pm/test/2/ ----- 9
/website/pm/new/ --------2
/website/keyboard/ -------3pages
...

Basically I want to find out the total number of pages for /website/pm/. So that includes 3 folders. In the example the number I would be looking for is 16.

To do this I filtered by the criteria "/website/pm/" and a simple equation added them up. =SUBTOTAL(9,B:B)

But this will take FOREVER as there are so many different levels of directories I want to find out the totals of and have recorded in a seperate spreadsheet. So I need someway of automating it to an extent.

Any ideas?

Many thanks,

Niall.