Editing Formula to not include a row- but maintaining everything else.
I have this formula:
=SUMIFS(CHILDREN(), CHILDREN($[Recruiter Name]@row), <>"PF External PRN") + ROUNDDOWN((SUMIF(CHILDREN($[Recruiter Name]@row), "PF External PRN", CHILDREN([2020-01]@row)) * 0.5))
I need to not count a row in the child rows called "Lawson Starts" while maintaining everything above as well. How would I do this? I tried listing it out separately and the formula ended up not rounding down the PF EXTERNAL ORN that I needed rounded down.
Help Article Resources
Check out the Formula Handbook template!