SUMIF with CHILDREN

Jill Youngberg

Working on a formula within a sheet where I am trying to sum estimate amounts based on their % closed. I have 2 categories we have created using children/parent (indenting) I want to only count the projects that are within 1 category. My formula is

=SUMIF(CHILDREN({A LEADS}), ({% CLOSE}=25%), CHILDREN({Amount})

This keeps coming back #unparsable. Any thoughts?

Jeff Reisman

Try changing your { } brackets to [ ].