SUMIF Formula question
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.
Comments
-
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)
-
Thank you Paul! It works as expected.
You are a huge help - you always respond quickly to my formula questions.
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!
