=COUNTIFS(A1:A10,"<>a",A1:A10,"<>b",A1:A10,"<>c",A1:A10,"<>d",A1:A10,"<>x")
Hi All
I need to count a range of cells whose value does not equal "a", "b", "c", "d", or "x"
need help with the syntax please
Many thanks as usual
Thanks Aladin
is it possible to add sumproduct to this or would it be better to use index and match or something else?
thanks very much