Adding Positive Parents

MikeCorvin ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello all,

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!