Sum Children formula

Laurie Bearden

Hi all. I am having an issue with getting a correct sum from children of a parent row when using a formula in the children rows.

Ex: Children row formula is =IF([Date Completed]43 > [Due Date]43, "1", "0")

There are two children rows; the formula above creates a 1 and a 0 respectively, however, my =SUM(CHILDREN()) formula returns with a 0. I have ensured that the rows are indented correctly. This happens everywhere I use these formulas together.

UPDATE: I have also found this issue when trying to add the child rows:

=SUM([Late Tasks]43:[Late Tasks]46

Formula Issue - 3-11-20.docx

Paul Newcome

Try removing the quotes from around your numbers. Putting quotes around them turns them into a text string as opposed to a numerical value.

Paul Newcome

Try removing the quotes from around your numbers. Putting quotes around them turns them into a text string as opposed to a numerical value.

Laurie Bearden

You're a genius! Thank you!

Paul Newcome

Happy to help! 👍️