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")
Help Article Resources
Check out the Formula Handbook template!