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")

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.