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