Thanks again .....One question thou.....why doesn't it work with the AND
condition after the IF statement...I have several other forumlas where I
have that?

Is it because the COUNT or frequency fromula can't combine AND?


--
ajajmannen
------------------------------------------------------------------------
ajajmannen's Profile: http://www.excelforum.com/member.php...o&userid=34130
View this thread: http://www.excelforum.com/showthread...hreadid=538999