COUNTIF

KColvin_civic1

I am trying to COUNTIF range 1 is yes then range 2 meets any of 3 criteria.

A single criteria works =COUNTIFS([Current Status]:[Current Status], "Active", [Milestone/Deliverable Name]:[Milestone/Deliverable Name], "Parent Project")

I need to add two additional criteria for the same second range. I want it to also count if Milestone/Deliverable Name is "Hourly Project" and "Monthly" for a total of three criteria in the second range.

Thank you!

Paul Newcome

Your criteria for that range would change to an OR Statement.

OR(@cell = "1st Option", @cell = "2nd Option", @cell = "3rd Option")

Paul Newcome

You need the opening and closing parenthesis as well as the "@cell" references.

Basically… Copy what I put in my last comment, paste it into the formula in the appropriate criteria section, then adjust each "Option" text to fit what you need.

Paul Newcome

Your criteria for that range would change to an OR Statement.

OR(@cell = "1st Option", @cell = "2nd Option", @cell = "3rd Option")

KColvin_civic1

Can you explain that as if I was a first grader? 😕

I tried this:

=COUNTIFS([Current Status]:[Current Status], "Active", [Milestone/Deliverable Name]:[Milestone/Deliverable Name], OR "Parent Project", "Hourly Project", "Monthly") and I got unparseable.

Paul Newcome

You need the opening and closing parenthesis as well as the "@cell" references.

Basically… Copy what I put in my last comment, paste it into the formula in the appropriate criteria section, then adjust each "Option" text to fit what you need.

KColvin_civic1

Thank you! that worked!

Paul Newcome

Happy to help. 👍️