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

I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need to have SUM formula update on row add/delete/move - Excel 2003 14
New computer, how do i move outlook 365 ENTIRELY? 0
How does "Search For" By or Subject work? 4
tell me the formula of converting amount to million from koror 1
under personal folders junk email has gone missing 0
A couple questions BEFORE using Office 365 0
what is geometric mean or return 2
rewrite numbers 0

Top