Question about SUMIFS with CHILDREN with multiple criteria
The sheet summary formula "TEST" which is looking for the number of recorded docs Alex did for Friday. What I have right now is =SUMIFS(CHILDREN(Recorded:Recorded), CHILDREN(Name:Name), "Alex", CHILDREN(Day:Day), TODAY(-3)). It works if I remove either the day criteria or the name criteria but returns zero as it is above. What I am trying to get per the sheet below is 11.
Help Article Resources
Check out the Formula Handbook template!