COUNTIFS with multiple criteria

August 23, 2016 at 20:59:33
Specs: Windows 7
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:

any suggestions?

See More: COUNTIFS with multiple criteria

Reply ↓  Report •

August 24, 2016 at 06:04:49
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

Reply ↓  Report •

August 24, 2016 at 07:01:32
Didn't I give you a SUMPRODUCT() formula for this a couple of weeks ago?


Reply ↓  Report •

Related Solutions

Ask Question