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

Using your data in cells A1:B5

D1: RED
E1: Yes
F1: =SUMPRODUCT(($A$1:$A$5=D1)*($B$1:$B$5=E1))

Also, if you give you list column headings (like:Color, Y/N) you could
use a pivot table to summarize your data.

Does that help?

Regards,
Ron


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

Thanks work perfectly.:)

Rik


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