More Count Help Please

S

SamGB

How do you get the COUNT function to count a range of ROWS based on 2
conditions?
i.e if the row contains A AND B it counts 1
but if the row contains A but NOT B it counts 0
and if the row does NOT contain A but DOES contain B it counts 0

any ideas?
many thanks
 
B

Bob Phillips

=IF(AND(COUNTIF(1:1,"A"),COUNTIF(1:1,"B"),1,0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top