I tried this and countif(a1:a10,"v") works

Naturally, the v is meant to be the tick symbol, you can give the cell
reference of the cell in your list that contains a tick.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=533656