The function is doing what it is suppose to do. The "counta" function
counts any string in the selected range.

Your formula has two strings in the range.

Frank


--
fcastrofilippo
------------------------------------------------------------------------
fcastrofilippo's Profile: http://www.excelforum.com/member.php...o&userid=36542
View this thread: http://www.excelforum.com/showthread...hreadid=564365