Thread: [Solved] Countif with 2 criteria
View Single Post
 
Old 05-22-2011, 09:31 AM
ibrahimaa ibrahimaa is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: May 2011
Posts: 35
ibrahimaa is on a distinguished road
Default Countif with 2 criteria

=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.
Reply With Quote