Count ifs criteria or sum product

[geliedee]

Hi All,

Good day.
Can someone help me with my problem?

I have here customers. These are duplicated.
I need a count ifs formula that will check if the one of the value in column R is not equal to A3.

Capture.JPG

If everything is A3 then it should passed.
If one of the value is not equal to A3, then failed.

[sktneer]

Maybe this....

Please Login or Register  to view this content.