Thank you so much , it works great

"Colin Vicary" wrote:


Hi

Assuming you column heading is in A1, paste this in an empty cell

=COUNTIF(A2:A5,"Y")+COUNTIF(A2:A5,"N")

Colin


--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472
View this thread: http://www.excelforum.com/showthread...hreadid=395841