Can you tell me what is wrong with this IF(C4:C99="OPEN")and(COUN.

[JE McGimpsey]

Not really. You need to post your question in the body of a message, not
just the subject...


"TBone" <[email protected]> wrote:

 

[Alan]

Post it so it can be seen and probably 'Yes'
Regards,

 

[Frank Kabel]

Hi
try positng your question as body of the message!

 

[Ian]

The answer really is that in Excel the 'and' isn't done like that.

You need to put IF ( AND(test1,test2,test3...),trueans,falseans)
Ian