I am trying to build a countifs formula to meet this complicated criteria: Criteria (range p7:p999 ="ONUS" or "OFFUS) AND (range g7:g999 <>DECL or <>WITH) AND range (g7:g999 = "CLOSED" AND et7:et999 = MONTH(Goals!$S$1))

The formula that I have is giving me a really high number that is incorrect:

=COUNTIFS($P$7:$P$999,"OFFUS",$ET$7:$ET$999,MONTH(Goals!$S$1))+COUNTIFS($P$7:$P$999,"ONUS",$ET$7:$ET$999,MONTH(Goals!$S$1))+COUNTIFS($G$7:$G999,"<>DECL")+COUNTIFS($G$7:$G999,"<>WITH")any suggestions?

Before I start working on a formula, you'll have to explain something to me: Your "written" criteria includes

g7:g999 = "CLOSED"but your formula does not include a test for that.Can you explain why that test is not included?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Ask Your Question

Weekly Poll

Do you think its a good idea for Amazon to divide its new second headquarters between two locations?

Discuss in The Lounge

Poll History