Parent Sum IF

CTSr

I've tried a variety of calculations, and can't seem to get the results I'm seeking.  I'm simply trying to add up all of the parent rows in a column called Resource Days that are Assigned To a specific team member.  Any suggestions?

=SUMIFS(PARENT(Resource Days:Resource Days), [Assigned To]:[Assigned To], "Team Member")

 

 

J. Craig Williams

You don't use PARENT in this case. 

Column names with spaces (or special characters) need square brackets []

=SUMIFS([Resource Days]:[Resource Days], [Assigned To]:[Assigned To], "Craig Williams")

However ...

Unfortunately, I don't think you can do it in a single formula, so:

1. add Checkbox column (I named mine [Is Parent])

2. In that column (row 1 and then copied to the rest of the column)

=COUNT(CHILDREN([Assigned To]1)) > 0

or

=IF(COUNT(CHILDREN([Assigned To]1)) > 0,1,0)

if that makes you feel better.

3. Your formula then becomes

=SUMIFS([Resource Days]:[Resource Days], [Assigned To]:[Assigned To], "Craig Williams", [Is Parent]:[Is Parent], 1)

I hope that helps.

Craig