Sum child to parent, with multiple levels

hi,

I have what I think is a rather "simple" request.

I have data set like this:

ID	no	ParrentID
1	1	
2	1	9
3	1	8
4	1	
5	1	3
6	1	
7	1	3
8	1	
9	1	1

And I want summed to something like this

ID	No Childs	Sum No
1	2		3
4	0		1
6	0		1
8	3		4

My actual dataset consists of 100k rows and can have up to 10 levels.


I will be happy with UDF, VBA or anything else as long as it gives me the wanted result


Any help will be greatly appreciated

Thanks!