Count IF And?

Kim Michael · 08/24/20

I am trying to determine my "deliverable count" based on if the following columns are in agreement

Project Phase checkbox is checked

Project Sub-Phase checkbox is checked

Status is "In Progress", "Not Started", "Roadblock", or blank

Purnima Gore · 08/24/20

Hi

Could you just provide a bit more please?

If Project Phase is checked and Project - Sub Phase is checked then the deliverable count is what? - 0, 1,2?

If you could write out here what were looking for in terms of the results that would be easier to understand.

Thanks

Purnima

Paul Newcome · 08/24/20

@Kim Michael I believe we got this figured out in your other post?

Kim Michael · 08/24/20

I have an answer to my inquiry. Thank you for reaching out.

Paul Newcome · 08/24/20

For anyone else that stumbles across this post looking for the solution, HERE is the thread that contains it.

Answers