Countif with two criteria

Excel Help for Countif With Two Criteria in Analyzing Corporate Financial Data

Countif With Two Criteria

Rate this: (3/5 from 1 vote)

	=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.
	Posted by ibrahimaa on 23 May 2011

Replies - Displaying 1 to 1 of 1

Order Replies By: Most Recent | Chronological | Highest Rated

	Adding COUNTIF statements Rate this: (3/5 from 1 vote) From the situation, it appears that you want to count cells in the range that have either 1 or are blank.  If this is the case, you can simple add multiple COUNTIF statements to return the total. e.g.: =COUNTIF($G$2:$G$17,1)+COUNTIF($G$2:$G$17,"")
	Excel Business Forums Administrator
	Posted by Excel Helper on 23 May 2011

Displaying page 1 of 1