COUNTIFS with multiple conditions

[rz6657]

I'm currently using the formula below to count the # of "In Progress" (column M) projects where the SI = 40500 (column K) and the deployment date is equal to / greater than 2018 (column N). However, the "In Progress" has been split into 4 different areas that still equate to being In Progress. I want all 4 counted under this formula, same cell but I'm stuck as to how.


=COUNTIFS(TechDev!M:M,D27,TechDev!K:K,D2,TechDev!N:N,">="&DATE(R2,1,1))

Four new areas:

1. Deployment
2. Development
3. New
4. Requirements

I'd attach a file but I'm not allowed...

thx

 

[steve the fish]

By 4 different areas do you mean 4 different columns? Easiest way would be to do the sum of 4 different countifs if so. This presumes only one of those columns would be filled at any one time.

 

[rz6657]

No, still all in the same column it just changed from In progress (only 1) to 4 different in the same column---

 

[steve the fish]

Like this?

=SUM(COUNTIFS(TechDev!M:M,{"Deployment","Development","New","Requirements"},TechDev!K:K,D2,TechDev!N:N,">="&DATE(R2,1,1)))

 

[rz6657]

Yes, perfect - thx so much---