I am looking to count the number of cells in a range which contain a specifc value but only if that range does not contain another specific value
EXAMPLE = Only count cells that contain the value "A" when the value "B" is not in the range.
Range A1:E1
Cell Values: A1 = A, B1 = A, C1 = A, D1 = B, E1 = D
As cell D1 contains the value "B" then the expected returned count value would be 0.
However if cell D1 contains a different value (e.g. C), then the returned count value would be 3
Range A1:E1
Cell Values: A1 = A, B1 = A, C1 = A, D1 = C, E1 = D
These are only example variables
Thanks in advance
EXAMPLE = Only count cells that contain the value "A" when the value "B" is not in the range.
Range A1:E1
Cell Values: A1 = A, B1 = A, C1 = A, D1 = B, E1 = D
As cell D1 contains the value "B" then the expected returned count value would be 0.
However if cell D1 contains a different value (e.g. C), then the returned count value would be 3
Range A1:E1
Cell Values: A1 = A, B1 = A, C1 = A, D1 = C, E1 = D
These are only example variables
Thanks in advance