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