Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Sum(If(RangeSum(A, B, C) = 1, D, 0)
Try Rangesum function, already suggested by Sunny, The Savior