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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"SamGB" wrote in
message ...

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


--
SamGB
------------------------------------------------------------------------
SamGB's Profile:
http://www.excelforum.com/member.php...o&userid=31263
View this thread: http://www.excelforum.com/showthread...hreadid=510334