Can any one help with this please I need to count the number
times a condition is meet in two cells.
IF A1=RED AND B1=YES
ie.

A B
1 RED YES
2 BLUE NO
3 RED NO
4 BLUE NO
5 RED YES

RESULT WOULD BE
RED YES=2
RED NO=1

Thanks
Rik


--
Rikuk
------------------------------------------------------------------------
Rikuk's Profile: http://www.excelforum.com/member.php...o&userid=26559
View this thread: http://www.excelforum.com/showthread...hreadid=502164