Adding Positive Parents
I am trying to set a formula up that adds the sum of several Parent lines, but only if they are positive. Adding all parents under one banner i use the Sum(Children) however, I tried to add only positive parents by using a SumIf(Cell1:Cell5, >0, Cell1:Cell5) but in doing so only managed to add all positive numbers underneath the parent cell as well (which amounts to about a million dollar difference so little bit of an issue). Does anyone know how I can set up, or even an exact formula that I can modify to make it only add up the positive parent cell amounts?
Help Article Resources
Check out the Formula Handbook template!