OR condition within range-criterion of COUNTIFS

Tanya Pammy

I want to get the count, where Workstreams columns is one of "Overarching", "Others","Cross-Topics" and status is "active", DEEP - DIVE:slid 1 Users is "int", DEEP - DIVE:slid 1 -Biz/Tech is "Business" and DEEP - DIVE:slid 1 FTE is "hired" . I am getting stuck with the first condition, of using OR in the first range-criterion.

=COUNTIFS({Workstreams}, "Overarching", {DEEP - DIVE:slid 1 -Status}, "active", {DEEP - DIVE:slid 1 Users}, "int", {DEEP - DIVE:slid 1 -Biz/Tech}, "Business", {DEEP - DIVE:slid 1 FTE}, "4. Int (hired)")

Please find the screenshot

Thanks,

Tanya.

James Keuning

I would add a helper column with a checkbox, a put an OR formula in there

OR(this, that, the other)

Then just use CHECKBOX,TRUE in your COUNTIFS.

James Keuning

I would add a helper column with a checkbox, a put an OR formula in there

OR(this, that, the other)

Then just use CHECKBOX,TRUE in your COUNTIFS.