Sum Children and not show "0"

Rascal

I am using =COUNT(CHILDREN()), but do not want the zero to show if sum is "0". Any suggestions on how to accomplish this? I tried adding IFERROR, but no luck.

Kelly Moore

Hey @Rascal

IF(COUNT(CHILDREN())>0,COUNT(CHILDREN()))

Will this work for you?

Kelly

Rascal

@Kelly Moore

THANK YOU!!!! I really do try to figure formulas out before asking for hep. Yes, it did work and can you assist with one more question?

I now want to Sum or Count all the values in the column, which of course may have a value in the child roll, summed up in to the parent row. I have approached with a variety of formulas with no success.

Any suggestions?

Thanks again!

Rascal

@Kelly Moore

I actually figured a formula out that will work....!! Can't believe I made it so difficult.

SUM(CHILDREN([Week21 5/22-5/28]3:[Week21 5/22-5/28]141)) - will display sum of children. If there is a "cleaner" formula I am happy to use.

THANKS!!

Kelly Moore

Hey @Rascal

Sorry for the delay in response- I've been leading trainings all week and haven't had a minute. I'm delighted you figured it out yourself! Great job! I hope you did a happy dance at your desk- that's what I do when I finally beat a difficult formula. (If you asked my colleagues they would tell you I really do dance 😉)