Sum Of Children (but don't add any negative value fields)

Nicole J

All,

I'm going nuts. I can't seem to figure out a simple formula that is essentially "sum of children, but don't factor in any children with negative values".

Can someone please help?

Many thanks,

Evan

Devin Lee

Hey @Nicole J

Give this a try

=SUMIF(CHILDREN(), >0, CHILDREN())

Devin Lee

Hey @Nicole J

Give this a try

=SUMIF(CHILDREN(), >0, CHILDREN())

Christina09

Hi @Nicole J

Use SUMIFS to set criteria only sum positive value:

=SUMIFS(CHILDREN(), CHILDREN(), >=0)

Nicole J

You're all lifesavers. Many thanks. Mission accomplished.