It's because the AND function only returns a single value, not an
array....

Hope this helps!

In article ,
ajajmannen
wrote:

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?