# Need help with a SUMIF formula

✭✭

I am trying to sum only the children of one of the parent rows of a column and only if the row has c

## Answers

• ✭✭✭✭✭✭
• ✭✭

Whoops, looks like the rest of my question was cut off. I need to sum the children of a parent row (Total ACTUALS- cell 7). This parent row is the child of another row. I only want to sum the children if the row has a checkbox checked in another column (column PMO).

Here are two formulas I tried

=SUMIF(COLLECT(CHILDREN([Total ACTUALS]7), (\$PMO:\$PMO), 1))

=SUMIFS(CHILDREN()), CHILDREN([Total ACTUALS]7), PMO:PMO, 1)

I then tried adding COUNT as suggested but that also drew an error.

• ✭✭✭✭✭✭

I dont understand what the [Total ACTUALS]7 is for. That is only reference 1 cell... so are you trying to just look at that cell? Also, please use @ to call out people since I don't get a notice if you reply without it. Can you share a screenshot? My best guess with the info you provided would be

=SUMIF(PMO:PMO,1,[Total ACTUALS]:[Total ACTUALS])

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!