SUMIFS with Multiple Conditions and Two Children Rows

Hi! I'm trying to work out the SUMIFS formula for a summary sheet based on multiple criteria that will SUM from two different children sum rows. Row 3 and Row 42 have the SUM(CHILDREN()) formula in those columns.


I can do it for one child row with the below formula for each but i need to add the two together.


=SUMIFS(CHILDREN([Annual GP]3), CHILDREN([Actual Month]3), ="November", CHILDREN (Client3), "QP")

=SUMIFS(CHILDREN([Annual GP]42), CHILDREN([Actual Month]42), ="November", CHILDREN (Client42), "QP")

Tags:

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are you putting this in the parent row for 3 and 42? If so, you could also just use

    =SUM(CHILDREN())

    for that one.


    If not, you can either add the cells together

    =[Column Name]3 + [Column Name]42


    or you can add the two SUMIFS together

    =1st_sumifs + 2nd_sumifs

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!