Parent Child addition

da

Hi ,

I need a help in calculation of data at lowest hierarchy level giving values to parent level.

For example,

l0	l1	L2	Data	Expected	Function used
A	a1	b1	11	33	=SUMIF
A	a1	b1	22	33
A	a2	b2	111	443
A	a2	b2	222	443
A	a2	b2	110	443

 

Here, I want values added of all the l2 who has same parent. Can anyone suggest me way out?

 

Thanks,

Divya