Sum of All Children of parents where Parent is of certain type

Shrikant Kekane

Hello,

I am trying to figure out a formula to sum all the children under a certain parent, where parent type = bug. I have a raw sheet which gives me a certain raw data as in the image below. I do not want to sum those children whose parent is of type story. Can someone please help? Below is just a sample sheet.

Thanks in advance!

Tatiana Kardosova

Hi Shrikant.

Suggestion from my side is to use additional column which you can hide.

Helper column formula: =IF(PARENT(Type@row) = "bug", 1, 0)

Total calculation: =SUMIF(helper:helper, 1, [Time Spend]:[Time Spend])