Home > Forum Home > Analyzing Corporate Financial Data > Countif with two criteria Share

Countif with two criteria

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


Forum TopicPost Reply Login

Countif With Two Criteria

Rate this:
(3/5 from 1 vote)
Confused=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 on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Oops
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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Countif with two criteria in the