Need help with a SUMIF formula

Options

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

  • CKRK
    CKRK ✭✭
    Options

    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
    Eric Law ✭✭✭✭✭✭
    Options

    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!