Parent Sum IF
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")