Using an expression for Countif conditions

[Anonymous]

Hey everybody,

I am trying to run a CountIf wherein whenever the SUM of A,B and C equals 1, D is counted.

For example, in the below picture, I should get a count of 3.

I tried a few expressions including the following one  =Count({<A+B+C=1>} D), but don't seem to get a result.

Would appreciate if I could get your thoughts on this.

Thanks in advance

[sunny_talwar]

May be this

Sum(If(RangeSum(A, B, C) = 1, D, 0)

[shiveshsingh]

Try Rangesum function, already suggested by Sunny, The Savior