Countif 2 conditions

[ibrahimaa]

=COUNTIF($G$2:$G$19,G8)=1

I want to edit the above formula to inject AND to make 2 criteria

This did not work: =COUNTIF(AND(($G$2:$G$17,G8)=1)G8 <>"")

What I want to happen is for the cell not to accept any input if G8 is not repeated and/or blank.

Any help is appreciated.

 

[T. Valko]

=COUNTIF($G$2:$G$19,G8)=1

I want to edit the above formula to inject AND to make 2 criteria

This did not work: =COUNTIF(AND(($G$2:$G$17,G8)=1)G8 <>"")

What I want to happen is for the cell not to accept any input if G8 is not repeated and/or blank.

Any help is appreciated.

It's not real clear what you mean.

Is this for data validation?

Maybe this:

=AND(COUNTIF($G$2:$G$17,G8)=1,G8 <>"")