SUMIF Formula question

Katye Reed

Hello,

I am attempting to create a formula that calculates the sum of the Actual Savings column, if the non-applicable column is not checked.  The formula I am using is =SUMIF(CHILDREN([Non DH Applicable?]@row), 1 + "").

 

Not sure why it isn't calculating correctly. 

Paul Newcome

There are a few issues with your formula. I would recommend giving this one a go instead...

 

=SUMIFS(CHILDREN(), CHILDREN([Non DH Applicable?]@row), 0)

Katye Reed

Thank you Paul! It works as expected. 

You are a huge help - you always respond quickly to my formula questions. 

Paul Newcome

Happy to help! 

 

Honestly the speedy response is nothing more than coincidental timing. I don't generally get on at the same time each day and there are days where I don't get on at all. Haha. But hey... At least you're getting the solutions you need.