Need help with a SUMIF formula

CKRK

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

Eric Law

https://community.smartsheet.com/discussion/114392/need-help-with-a-sumif-formula

=COUNT(CHILDREN())

CKRK

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.

Eric Law

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])