Hello,
I have a COUNTIF formula that contains an array that isn't working for me. The problem seems to be in the 'does not' (<>) section of the formula. The formula always returns results, but the count is incorrect.
I've anonymised the code below - so hopefully still understandable. The A2 at the end is the username in Sheet2 R:R.
Thanks for the help!
I have a COUNTIF formula that contains an array that isn't working for me. The problem seems to be in the 'does not' (<>) section of the formula. The formula always returns results, but the count is incorrect.
I've anonymised the code below - so hopefully still understandable. The A2 at the end is the username in Sheet2 R:R.
Excel Formula:
=COUNTIF('Sheet2'!G:G,"Condition 1",'Sheet2'!I:I,{"<>ConditionA","<>ConditionB","<>ConditionC","<>ConditionD","<>ConditionE","<>ConditionF","<>ConditionG"},'Sheet2'!N:N,"Condition 2",'Sheet2'!O:O,"Condition 3",'Sheet2'!R:R,A2)
Thanks for the help!